DateFunction | SQL Query | Result |
Get Year | SELECT DATENAME(YEAR, GETDATE()) AS 'Year' | 2021 |
Get Quarter | SELECT DATENAME(QUARTER, GETDATE()) AS 'Quarter' | 3 |
Month Name | SELECT DATENAME(MONTH, GETDATE()) AS 'Month Name' | August |
DayOfYear | SELECT DATENAME(DAYOFYEAR, GETDATE()) AS 'DayOfYear' | 236 |
DAY | SELECT DATENAME(DAY, GETDATE()) AS 'Day' | 24 |
Week | SELECT DATENAME(WEEK, GETDATE()) AS 'Week' | 35 |
DayOfWeek | SELECT DATENAME(WEEKDAY, GETDATE()) AS 'DayOfWeek' | Tuesday |
Hour | SELECT DATENAME(HOUR, GETDATE()) AS 'Hour' | 22 |
Minute | SELECT DATENAME(MINUTE, GETDATE()) AS 'Minute' | 12 |
Second | SELECT DATENAME(SECOND, GETDATE()) AS 'Second' | 30 |
MilliSecond | SELECT DATENAME(MILLISECOND, GETDATE()) AS 'MilliSecond' | 840 |
MicroSecond | SELECT DATENAME(MICROSECOND, GETDATE()) AS 'MicroSecond' | 840000 |
NanoSecond | SELECT DATENAME(NANOSECOND, GETDATE()) AS 'NanoSecond' | 840000000 |
Week | SELECT DATENAME(ISO_WEEK, GETDATE()) AS 'Week' | 34 |
| | |