u can use dateadd() and datediff() functions to manipulate date data type
above funtions are add two date and subtract one date from other date
but here datediff function does not give proper...