Mega Code Archive

 

Categories / MSSQL / Date Timezone

 

DATENAME

3> -- DATENAME: return the part of the date in a literal form. 4> 5> SELECT DATENAME(mm,GETDATE()) 6> GO ------------------------------ October (1 rows affected) 1> --------------------------------------------------------- 2>