MySQL Tutorial MySQL Advanced MySQL Database Account Management MySQL References

MySQL LOCALTIME() Function



The MySQL LOCALTIME() 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 LOCALTIME(), CURRENT_TIMESTAMP() and LOCALTIMESTAMP() functions are a synonyms for the NOW() function.

Syntax

LOCALTIME()

Parameters

No parameter is required.

Return Value

Returns the current date and time.

Example 1:

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

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

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

mysql> SELECT LOCALTIME() + 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 query can be used.

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

-- 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

5