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






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

-----------
         19

(1 rows affected)
1>








10.9.Day
10.9.1.Displaying the Integer Value For Part of a Date using DAY
10.9.2.YEAR, MONTH, DAY
10.9.3.select DAY('2002-09-30')