timestamp_millis function
Applies to: Databricks SQL
Databricks Runtime
Creates a timestamp expr milliseconds since UTC epoch.
Syntax
timestamp_millis(expr)
Arguments
expr: An integral numeric expression specifying milliseconds.
Returns
A TIMESTAMP.
If expr is out of the range representable as a TIMESTAMP, Databricks raises ARITHMETIC_OVERFLOW.
Common error conditions
Examples
SQL
> SELECT timestamp_millis(1230219000123);
2008-12-25 07:30:00.123
> SELECT timestamp_millis(92233720368547758);
Error: ARITHMETIC_OVERFLOW