i try these function but i fail to get my requirement.


>format is never gonna give you that result.
>see all date related function.
>Use datediff,datepart and dateadd functions, you will get what you want