Mega Code Archive

 

Categories / MSSQL Tutorial / Date Functions

 

DATEDIFF returns the difference between two dates as specified by datepart

4> 5> SELECT DATEDIFF(DY,"08/30/97","10/01/97") 6> GO -----------          32 (1 rows affected) 1>