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

How useful was this post?

Click on a star to rate it!

Average rating / 5. Vote count:

As you found this post useful...

Follow us on social media!

We are sorry that this post was not useful for you!

Let us improve this post!

Leave a Reply

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