unix_date function
Applies to: 
Databricks SQL Databricks Runtime
Returns the number of days since 1970-01-01.
unix_date(expr)
expr: A DATE expression.
An INTEGER.
> SELECT unix_date(DATE('1970-01-02'));
1
This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
unix_date functionApplies to: Databricks SQL Databricks Runtime
Returns the number of days since 1970-01-01.
unix_date(expr)
expr: A DATE expression.An INTEGER.
> SELECT unix_date(DATE('1970-01-02'));
1