can you tell me how can i execute datediff in sql

Question

please help me in use datediff statement

Answer 1

Hi ,

DATEDIFF is a function that is used for determining the difference in month , date , year , quarter  month and several other atuffs related to date and time between a range of dates.
Returns the count (signed integer) of the specified datepart boundaries crossed between the specified startdate and enddate
There is much to read about it from
http://msdn.microsoft.com/en-us/library/ms189794.aspx
http://msdn.microsoft.com/en-us/library/ms189794(SQL.90).aspx


The syntax is -

DATEDIFF ( datepart , startdate , enddate )

---

Thanks, Leks