date_from_unix_date function

Creates a date from the number of days since 1970-01-01.

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.

This function is a synonym for date_add(DATE'1970-01-01', days).

Examples

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