Get started
Load & manage data
Work with data
Administration
Reference & resources
CLUSTER BY
mask
ROW FILTER
Updated Nov 04, 2024
Send us feedback
unix_micros
Applies to: Databricks SQL Databricks Runtime
Returns the number of microseconds since 1970-01-01 00:00:00 UTC.
1970-01-01 00:00:00 UTC
unix_micros(expr)
expr: A TIMESTAMP expression.
expr
A BIGINT.
> SELECT unix_micros(TIMESTAMP('1970-01-01 00:00:01Z')); 1000000
unix_date function
unix_millis function
unix_seconds function