Skip to main content
Version: 24.3.x

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