TIMESTAMP_MILLIS
timestamp_millis(millis)
Description
The TIMESTAMP_MILLIS function is used to convert the number of milliseconds since the Unix epoch (00:00:00 UTC on January 1, 1970) into a timestamp format.
Parameter Description
- millis: bigint type, representing the number of milliseconds since the Unix epoch.
Return Result
Returns a value in timestamp format, representing the exact date and time corresponding to the input milliseconds.
Usage Example
- Convert the current time's milliseconds into timestamp format:
SELECT TIMESTAMP_MILLIS(UNIX_TIMESTAMP() * 1000) as res;
+---------------------+
| res |
+---------------------+
| 2025-01-21 16:02:51 |
+---------------------+
- Convert specific milliseconds to a timestamp and display the result:
SELECT TIMESTAMP_MILLIS(1695364065000 + 123456) as res;
+-------------------------+
| res |
+-------------------------+
| 2023-09-22 14:29:48.456 |
+-------------------------+
- Convert the past time in milliseconds to a timestamp and compare it with the current timestamp:
SELECT TIMESTAMP_MILLIS(1623370800000)as res1, CURRENT_TIMESTAMP() as res2;
+---------------------+----------------------------+
| res1 | res2 |
+---------------------+----------------------------+
| 2021-06-11 08:20:00 | 2025-01-21 16:04:16.042245 |
+---------------------+----------------------------+
