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

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

Related functions

• date_add (days) function
• date_sub function