SQL NOW

The SQL NOW() function will return current date and time based on server system.

It is supported by MySQL, in MS SQL Server, the function getdate() will do the same thing, and in Oracle we can use SELECT SYSDATE FROM DUAL to get the current date and time.

SQL NOW() Syntax

SELECT NOW()

SQL NOW() Example

Table: Employees

We want to insert a new employee to the table:

INSERT INTO Employees(FirstName, LastName, Created)
VALUES('Goood', 'Yofdae', NOW())

After inserted the new employee, the table Employees will have one more record: