Query to get current date/time in sql server

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.