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, Azure Databricks raises ARITHMETIC_OVERFLOW.

Common error conditions

• ARITHMETIC_OVERFLOW

Examples

> SELECT timestamp_millis(1230219000123);
 2008-12-25 07:30:00.123

> SELECT timestamp_millis(92233720368547758);
  Error: ARITHMETIC_OVERFLOW

Related functions

• timestamp function
• timestamp_micros function
• timestamp_seconds function