| Sr.No. |
Function & Description |
| 1 |
@@DATEFIRST
This function is used to retrieve the first day of the week which is set by the SET DATEFIRST function. |
| 2 |
CURRENT_TIMESTAMP
Is used to retrieve the current date and time. |
| 3 |
CURRENT_TIMEZONE()
This function is used to retrieve the current time zone offset from Coordinated Universal Time (UTC). |
| 4 |
CURRENT_TIMEZONE_ID()
Is used to retrieve the current time zone ID observed by a server or an instance. |
| 5 |
DATE_BUCKET()
Is used to group data into groups that correspond to fixed periods of time. |
| 6 |
DATEADD()
Is used to add a specific number of intervals to a given date or time value. |
| 7 |
DATEDIFF()
Is used to calculate the difference between two date values and returns in a int data type. |
| 8 |
DATEDIFF_BIG()
Is used to calculate the difference between two dates values and return in a bigint data type. |
| 9 |
DATEFROMPARTS()
This function is used to retrieve a date from individual segments such as year, month, and day. |
| 10 |
DATENAME()
This function is used to retrieve a specified part of a date or time value as string. |
| 11 |
DATEPART()
Is used to return a specified part of a date or time value as integer. |
| 12 |
DATETIME2FROMPARTS()
Is used to construct a datetime2 value from an individual date and time segments. |
| 13 |
DATETIMEFROMPARTS()
Is used to construct a datetime value from an individual date and time segments. |
| 14 |
DATETIMEOFFSETFROMPARTS()
Is used to extract a datetimeoffset value from each of a date's component parts. |
| 15 |
DATETRUNC()
Is used to truncate a date or time value to a specified datepart (such as year, month, day, etc.). |
| 16 |
DAY()
This function is used to get the day of the month for a specified date. |
| 17 |
EOMONTH()
This function is used to get the last day of the month for a specified date value. |
| 18 |
GETDATE()
This function is used to get the current database system date and time. |
| 19 |
GETUTCDATE()
This function is used to get the current database system UTC date and time. |
| 20 |
ISDATE()
Is used to determine whether a value is a valid date or not. |
| 21 |
MONTH()
This function is used to get the month part for a specified date (value can be from 1 to 12). |
| 22 |
SMALLDATETIMEFROMPARTS()
Is used to construct a new datetime value from individual segments (such as year, month, etc.). |
| 23 |
SWITCHOFFSET()
This function is used to get datetimeoffset values that has been changed from the stored time zone offset to a given new time zone offset. |
| 24 |
SYSDATETIME()
This function is used to get the date and time of the SQL Server. |
| 25 |
SYSDATETIMEOFFSET()
This function is used to get a value of DATETIMEOFFSET(7) that provides the current system date and time and also timezone of the SQL server. |
| 26 |
SYSUTCDATETIME()
This function is used to get date and time of the computer on which the instance of SQL Server is running. |
| 27 |
TIMEFROMPARTS()
Is used to construct a time value from individual segments. |
| 28 |
TODATETIMEOFFSET()
This function is used to get a datetimeoffset value that is translated from a datetime2 expression. |
| 29 |
YEAR()
This function is used to get an integer number that represents the year of the given date. |
