Get started
Load & manage data
Work with data
Administration
Reference & resources
CLUSTER BY
mask
ROW FILTER
Atualizado 14/02/2025
Send us feedback
date_from_unix_date
Applies to: Databricks SQL Databricks Runtime
Creates a date from the number of days since 1970-01-01. This function is a synonym for date_add(DATE'1970-01-01', days).
1970-01-01
date_add(DATE'1970-01-01', days)
date_from_unix_date(days)
days: An INTEGER expression.
days
A DATE.
If days is negative the days are subtracted from 1970-01-01.
> SELECT date_from_unix_date(1); 1970-01-02
date_add (days) function
date_sub function