FROM_MICROSECOND
Description
The function converts a Unix timestamp (in microseconds) into a DATETIME value.
Syntax
FROM_MICROSECOND(<unix_timestamp>)
Parameters
| Parameter | Description |
|---|---|
<unix_timestamp> | Required. The Unix timestamp representing the number of microseconds elapsed since 1970-01-01 00:00:00 UTC. |
Return Value
- Returns a DATETIME value representing the date and time corresponding to the given Unix timestamp.
- If
<unix_timestamp>is NULL, the function returns NULL. - If
<unix_timestamp>is out of valid range, the function returns an error.
Example
SELECT FROM_MICROSECOND(1700000000000000);
+------------------------------------+
| from_microsecond(1700000000000000) |
+------------------------------------+
| 2023-11-15 06:13:20 |
+------------------------------------+
