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. |
it will helps you…