SQL
SQL Server Date Functions
![](https://blog.codehunger.in/wp-content/uploads/2020/06/SQL-Server-Date-Functions-1.png)
This page lists the most commonly used SQL Server Date functions that allow you to handle date and time data effectively.
![](https://blog.codehunger.in/wp-content/uploads/2020/06/SQL-Server-Date-Functions-1-1024x433.png)
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. |
it will helps you…