unix_date
function
Applies to: Databricks SQL Databricks Runtime
Returns the number of days since 1970-01-01
.
Syntax
unix_date(expr)
Arguments
expr
: A DATE expression.
Returns
An INTEGER.
Examples
> SELECT unix_date(DATE('1970-01-02'));
1