select MONTH('2002-09-30') : Month « Date Timezone « SQL Server / T-SQL






select MONTH('2002-09-30')

 


3> select MONTH('2002-09-30')
4> GO

-----------
          9

(1 rows affected)
1>

 








Related examples in the same category

1.MONTH: return the month portion of a date
2.The DAY(), MONTH(), and YEAR() Functions
3.Month(Date) function