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.
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()
Thanks for comments.....