date_from_unix_date function
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).
Syntax
date_from_unix_date(days)
Arguments
days: An INTEGER expression.
Returns
A DATE.
If days is negative the days are subtracted from 1970-01-01.
Examples
SQL
> SELECT date_from_unix_date(1);
1970-01-02