Difference BETWEEN GETDATE And SYSDATETIME Function In SQL Server

Difference b/w GETDATE And SYSDATETIME Function In SQL Server

GETDATE()

SELECT GETDATE() AS DATE

GETDATE() RETURN ONLY CURRENT DATABASE SYSTEM TIME STAMP  AS A DATETIME VALUE WITHOUT

WITHOUT TIME ZONE OFFSET.THIS VALUE IS DERIVED FROM OPERATING SYSTEM OF THE COMPUTER ON WHICH THE INSTANCE OF SQL SERVER IS RUNNING

SYSDATETIME()

RETURN DATETIME () VALUE THAT CONTAIN DATE AND TIME OF THE  COMPUTER ON WHICH THE INSTANCE OF SQL SERVER IS RUNNING

Leave a Reply

Your email address will not be published. Required fields are marked *