Date and Time Functions

---

Date and Time Functions in SQL Server

Date and time functions in SQL server are scalar functions that perform an operation on a date and time input value and returns either a string, numeric, or date and time value.

All functions are listed below:

Function	Description
CURRENT_TIMESTAMP	Returns a datetime2(7) value that contains the date and time of the computer on which the instance of SQL Server is running. The time zone offset is not included.

Syntax:

CURRENT_TIMESTAMP

Function	Description
DATEADD	Returns a new datetime value based on adding an interval to the specified date.

Syntax:

DATEADD (datepart , number, date )

Function	Description
DATEDIFF	Returns the number of date and time boundaries crossed between two specified dates.

Syntax:

DATEDIFF ( datepart , startdate , enddate )

Function	Description
DATENAME	Returns a character string representing the specified datepart of the specified date.

Syntax:

DATENAME ( datepart ,date )

Function	Description
DATEPART	Returns an integer that represents the specified datepart of the specified date.

Syntax:

DATEPART ( datepart , date )

Function	Description
DAY	Returns an integer representing the day datepart of the specified date.

Syntax:

DAY ( date )

Function	Description
GETDATE	Returns the current system date and time in the SQL Server standard internal format for datetime values.

Syntax:

GETDATE ( )

Function	Description
GETUTCDATE	Returns the datetime value representing the current UTC time (Coordinated Universal Time or Greenwich Mean Time).

Syntax:

GETUTCDATE ( )

Function	Description
ISDATE	Determines whether a datetime or smalldatetime input expression is a valid date or time value

Syntax:

ISDATE ( expression )

Function	Description
MONTH	Returns an integer that represents the month part of a specified date.

Syntax:

MONTH ( date )

Function	Description
YEAR	Returns an integer that represents the year part of a specified date.

Syntax:

YEAR ( date )

Function	Description
SWITCHOFFSET	SWITCHOFFSET changes the time zone offset of a DATETIMEOFFSET value and preserves the UTC value.

Syntax:

SWITCHOFFSET ( DATETIMEOFFSET, time_zone )

Function	Description
TODATETIMEOFFSET	TODATETIMEOFFSET transforms a datetime2 value into a datetimeoffset value. The datetime2 value is interpreted in local time for the specified time_zone.

Syntax:

TODATETIMEOFFSET ( expression, time_zone )

Function	Description
SYSDATETIME	Returns a datetime2(7) value that contains the date and time of the computer on which the instance of SQL Server is running. The time zone offset is not included.

Syntax:

SYSDATETIME ( )

Function	Description
SYSDATETIMEOFFSET	Returns a datetimeoffset(7) value that contains the date and time of the computer on which the instance of SQL Server is running. The time zone offset is included.

Syntax:

SYSDATETIMEOFFSET ( )

Function	Description
SYSUTCDATETIME	Returns a datetime2(7) value that contains the date and time of the computer on which the instance of SQL Server is running. The date and time is returned as UTC time (Coordinated Universal Time).

Syntax:

SYSUTCDATETIME ( )