The DATEPART and DATENAME functions produce the specified part of a datetime value (the year, quarter, day, hour, and so on) as either an integer or an ASCII string. Because smalldatetime is accurate only to the minute, when a smalldatetime value is used with either of these functions, the seconds and milliseconds returned are always zero.
These examples assume the date May 29:
SELECT DATEPART(month, GETDATE()) |
|
|
Here is the result set: |
|
------------ |
|
5 |
|
(1 row(s) affected) |
|
SELECT DATENAME(month, GETDATE()) |
|
|
Here is the result set:
|
|
May |
|
(1 row(s) affected) |
|