date_from_unix_date function

Applies to: check marked yes Databricks SQL check marked yes 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 

> SELECT date_from_unix_date(1);
 1970-01-02