Mega Code Archive

 

Categories / MSSQL Tutorial / Date Functions

 

DATEPART Function returns the integer value of the datepart specified

4> 5> SELECT DATEPART(MM,"Oct 31 1997") 6> GO -----------          10 (1 rows affected) 1>