| 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 |
| | | |