Tag: Date and Time Functions in sql

Date and Time Functions
T-SQL supports a many date and time functions that allow you to manipulate your date and time data.
Current date and time
T-SQL supports built- in functions like GETDATE, GETUTCDATE, CURRENT_TIMESTAMP, SYSDATETIME, SYSUTCDATETIME and SYSDATETIMEOFFSET that returns the current date and time.
CURRENT_TIMESTAMP:
Returns the current date and