MySQL UNIX_TIMESTAMP() Function

The MySQL UNIX_TIMESTAMP() function returns a Unix timestamp representing seconds since '1970-01-01 00:00:00' UTC. If datetime argument is not provided, the function returns the current Unix timestamp. If the datetime argument is provided, it returns the Unix timestamp for the specified datetime.

The datetime argument can be a DATE, DATETIME, TIMESTAMP string, or a number in YYMMDD, YYMMDDhhmmss, YYYYMMDD, or YYYYMMDDhhmmss format.

Syntax

UNIX_TIMESTAMP(datetime)

Parameters

Return Value

Returns the Unix timestamp.

Example 1:

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

mysql> SELECT UNIX_TIMESTAMP();
Result: 1641883574

mysql> SELECT UNIX_TIMESTAMP('2019-10-25');
Result: 1571961600

mysql> SELECT UNIX_TIMESTAMP('2019-10-25 08:10:25');
Result: 1571991025

mysql> SELECT UNIX_TIMESTAMP(20191025);
Result: 1571961600

mysql> SELECT UNIX_TIMESTAMP(20191025081025);
Result: 1571991025

mysql> SELECT UNIX_TIMESTAMP(NULL);
Result: NULL

Example 2:

Consider a database table called Sample with the following records:

The statement given below can be used to convert the records of column LoginStamp into Unix timestamp.

SELECT *, UNIX_TIMESTAMP(LoginStamp) AS UNIX_TIMESTAMP_Value FROM Sample;

This will produce the result as shown below: