Date Functions

This page lists the most commonly used SQL Server Date functions that allow you to handle date and time data effectively.


Returning the current date and time


Function Description

CURRENT_TIMESTAMP Returns the current system date and time without the time zone part.

GETUTCDATE Returns a date part of a date as an integer number.

GETDATE Returns the current system date and time of the operating system on

which the SQL Server is running.

SYSDATETIME Returns the current system date and time with more fractional

seconds precision than the GETDATE() function.

SYSUTCDATETIME Returns the current system date and time in UTC time

SYSDATETIMEOFFSET Returns the current system date and time with the time zone.



Returning the date and time Parts


Function Description

DATENAME Returns a date part of a date as a character string

DATEPART Returns a date part of a date as an integer number

DAY Returns the day of a specified date as an integer

MONTH Returns the month of a specified date as an integer

YEAR Returns the year of the date as an integer.



Returning a difference between two dates


Function Return value

DATEDIFF Returns a difference in date part between two dates.


Modifying dates


Function Description

DATEADD Adds a value to a date part of a date and return the new date value.

EOMONTH Returns the last day of the month containing the specified date, with

an optional offset.

SWITCHOFFSET Changes the time zone offset of a DATETIMEOFFSET value and

preserves the UTC value.

TODATETIMEOFFSET Transforms a DATETIME2 value into a DATETIMEOFFSET value.



Constructing date and time from their parts


Function Description

DATEFROMPARTS Return a DATE value from the year, month, and day

DATETIME2FROMPARTS Returns a DATETIME2 value from the date and time arguments

DATETIMEOFFSETFROMPARTS Returns a DATETIMEOFFSET value from the date and time

arguments

TIMEFROMPARTS Returns a TIME value from the time parts with the precisions


Validating date and time values


Function Description

ISDATE Check if a value is a valid date, time, or datetime value


Source: Guru99

Recent Posts

See All

Window Functions

SQL Server Window Functions calculate an aggregate value based on a group of rows and return multiple rows for each group. Name Description CUME_DIST Calculate the cumulative distribution of a v

String Functions

The following SQL Server string functions process on an input string and return a string or numeric value: Function Description ASCII Return the ASCII code value of a character CHAR Con