Displaying the Integer Value For Part of a Date using MONTH : MONTH « Date Functions « SQL Server / T-SQL Tutorial






  1. SQL Server / T-SQL Tutorial
  2. Date Functions
  3. MONTH
3>
4> SELECT MONTH(GETDATE())
5> GO

-----------
         10

(1 rows affected)








10.13.MONTH
10.13.1.Displaying the Integer Value For Part of a Date using MONTH
10.13.2.select MONTH('2002-09-30')