get current system date time in SQL Server

Description:-

In this article we will see about how to get system date and time using Sql server. there are many functions to get current system date time in Sql server. here is the different ways to get current system date and time.
 
SELECT 'SYSDATETIME' AS FunctionName, SYSDATETIME() AS DateTimeFormat
SELECT 'SYSDATETIMEOFFSET', SYSDATETIMEOFFSET()
SELECT 'SYSUTCDATETIME', SYSUTCDATETIME()
SELECT 'CURRENT_TIMESTAMP', CURRENT_TIMESTAMP
SELECT 'GETDATE', GETDATE()
SELECT 'GETUTCDATE', GETUTCDATE() 

Related Posts

Previous
Next Post »

Thanks for comments.....