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
|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…
Do you want to hire us for your Project Work? Then Contact US.