SQL
SQL Server Dates
Dates:
| Requirement | Query | Display format |
|---|---|---|
| Current date time | Select GetDate() | 2022-01-01 11:30:40.678 |
| current date time | Select Current_timestamp | 2022-01-01 11:30:40.678 |
| current date time | Select SYSDatetime() | 2022-01-01 11:30:40.1282463 |
| current year | Select Year(GetDate()) | 2022 |
| current year | Select Datepart(Year, GetDate()) | 2022 |
| current month | Select Month(GetDate()) | 1 |
| current month | Select Datepart(Month, GetDate()) | 1 |
| Add an year to current date | Select DateAdd(Year,1,GetDate()) | 2023-01-01 11:30:40.678 |
| Subtract an year to current date | Select DateAdd(Year,-1,GetDate()) | 2021-01-01 11:30:40.678 |
| Name of current month | Select Datename(Month, GetDate()) | January |
| Current date in mm/dd/yyyy | Select Convert(varchar,GetDate(),101) | 01/01/2022 |
| End of month | Select EOMONTH(Sysdatetime()) | 2022-01-31 |
| First day of month | Select DateAdd(month,Datediff(month, ‘19000101’,Sysdatetime()),’19000101′) | 2022-01-01 00:00:00.000 |