In this article, we learn about Date Time Function in SQL Server.
CURRENT_TIMESTAMP
- The CURRENT_TIMESTAMP function returns the current timestamp of the operating system. The returned timestamp is a DATETIME value without the time zone offset.
- Syntax: CURRENT_TIMESTAMP
DATEADD
- The DATEADD() function adds a time/date interval to date and then returns the date.
- Syntax: DATEADD(interval, number, date)
DATEDIFF
- The DATEDIFF() function returns the difference between two dates.
- Syntax: DATEDIFF(interval, start_date , end_date)
DATENAME
- The DATENAME() function returns a specified part of a date. It returns a string value.
- Syntax: DATENAME(interval, date)
DATEPART
- The DATEPART() function returns a specified part of a date. It returns an integer value.
- Syntax: DATENAME(interval, date)
DAY
- The DAY() function returns the day of the month (from 1 to 31) for a specified date.
- Syntax: DAY(date)
GETDATE
- The GETDATE() function returns the current database system date-time format.
- Syntax: GETDATE()
GETUTCDATE
- The GETUTCDATE() function returns the current database system UTC date-time format.
- Syntax: GETUTCDATE()
MONTH
- The MONTH() function returns the month part for a specified date.
- Syntax: MONTH(date)
YEAR
- The YEAR() function returns the year part for a specified date.
- Syntax: YEAR(date)
If you are a newbie to database learning — SQL Server recommended is the following must-watch video: -