SQL Tutorial SQL Advanced SQL Database SQL References

MySQL NOW() Function



The MySQL NOW() function returns the current date and time. It returns the current date and time in the following format:

  • Returns the current date and time as a 'YYYY-MM-DD HH:MM:SS' format, if used in a string context.
  • Returns the current date and time as a YYYYMMDDHHMMSS.uuuuuu format, if used in a numeric context.

The CURRENT_TIMESTAMP(), LOCALTIME(), and LOCALTIMESTAMP() functions are a synonyms for the NOW() function.

Syntax

NOW()

Parameters

No parameter is required.

Return Value

Returns the current date and time.

Example 1:

The example below shows the usage of NOW() function.

mysql> SELECT NOW();
Result: '2021-12-27 05:11:57'

mysql> SELECT NOW() + 0;
Result: 20211227051157

mysql> SELECT NOW() + 1;
Result: 20211227051158

Example 2:

Consider a database table called EmployeeLogin with the following records:

EmpIDNameLogin Stamp
1John2019-10-25 09:20:38
2Marry2019-10-25 09:21:05
3Jo2019-10-25 09:24:35
4Kim2019-10-25 09:25:24
5Ramesh2019-10-25 09:27:16

To insert a new record in this table, the following statement can be used.

INSERT INTO EmployeeLogin 
VALUES (6, 'Suresh', NOW());

-- see the result
SELECT * FROM EmployeeLogin;

This will produce a result similar to:

EmpIDNameLogin Stamp
1John2019-10-25 09:20:38
2Marry2019-10-25 09:21:05
3Jo2019-10-25 09:24:35
4Kim2019-10-25 09:25:24
5Ramesh2019-10-25 09:27:16
6Suresh2019-10-25 09:28:19

❮ MySQL Functions