SQL NOW() and SQL-Server GETDATE() Function

SQL NOW() and SQL-Server GETDATE() Function

NOW() – The sql function NOW() is returns current system date and time.

The sql syntax of NOW() is :

SELECT NOW() FROM Table_Name

In SQL Server we use GETDATE() function to get current date and time.

The syntax of GETDATE() is :

SELECT GETDATE();
SELECT GETDATE() FROM Table_Name

Let’s understand SQL NOW() and GETDATE() function with an example :

We have SQL Table StudentMst with below column.

SELECT * FROM StudentMst

SELECT ID, Name, City, Pincode, GETDATE() as DATE FROM StudentMst

SELECT GETDATE() AS DATE