ReferenceSQL language referenceFunctionsBuilt-in functionsAlphabetical list of built-in functionsunix_date functionOn this pageunix_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 SQL> SELECT unix_date(DATE('1970-01-02')); 1 Related functions unix_micros function unix_millis function unix_seconds function