MONTH: return the month portion of a date : Month « Date Timezone « SQL Server / T-SQL






  1. SQL Server / T-SQL
  2. Date Timezone
  3. Month

MONTH: return the month portion of a date

12>
13> -- MONTH: return the month portion of a date.
14>
15> SELECT MONTH("24 March 1964")
16> GO

-----------
          3

(1 rows affected)








Related examples in the same category

1.The DAY(), MONTH(), and YEAR() Functions
2.Month(Date) function
3.select MONTH('2002-09-30')