Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
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, Azure Databricks raises ARITHMETIC_OVERFLOW.
Common error conditions
Examples
> SELECT timestamp_millis(1230219000123);
2008-12-25 07:30:00.123
> SELECT timestamp_millis(92233720368547758);
Error: ARITHMETIC_OVERFLOW