FROM_UNIXTIME
Convert Epoch seconds to a timestamp.
Warning note
This function uses Epoch seconds as a value, to convert Epoch Milliseconds value divide the value by a thousand (value/1000)
Syntax
FROM_UNIXTIME(unix_timestamp)
Arguments
| value | Type | Description | Default Value |
|---|---|---|---|
| unix_timestamp | numeric |
Returns
timestamp
Examples
| datetime | Output |
|---|---|
| 1641000600 | timestamp "2022-01-01 01:30:00" |
| 1520672112.456 | timestamp "2018-03-10 08:55:12.456" |