Mega Code Archive

 

Categories / MSSQL / Date Timezone

 

DATENAME(month, 4-29-1988) returns a string containing the descriptive name

1> 2> SELECT DATENAME(month, '4-29-1988') 3> GO ------------------------------ April (1 rows affected) 1> 2>