Query to get current date/time in sql server

By
Advertisement

Introduction:

In this article I am going to explain the different queries used to get the current date/time in sql server.

Explanation:

In sql server to get the current date/time three system defined functions are used.They are  CURRENT_TIMESTAMP,fn NOW(),GETDATE().



SQL Query:

SELECT CURRENT_TIMESTAMP
GO
SELECT {fn NOW()}
GO
SELECT GETDATE()
GO

Do you like this article. Then comment here or share with your friends. Or like our facebook page.

0 comments:

Post a Comment

Online Casino