Categories: Date/Time

DATETYPE

Constructs DATE using the values provided for year, month, and day parameters.

Syntax

DATETYPE(year NUMERIC, month NUMERIC, day NUMERIC) → DATE

• year: Year value.
• month: Month value.
• day: Day value.

Examples

DATETYPE example

SELECT DATETYPE(2020,1,2)
-- 2020-01-02