Skip to main content

Categories: Date/Time

TIMESTAMPTYPE

Constructs a timestamp using the values provided for year, month, day, hour, minute, second, and millisecond parameters.

Syntax​

TIMESTAMPTYPE(year NUMERIC, month NUMERIC, day NUMERIC, hour NUMERIC, minute NUMERIC, second NUMERIC, millisecond NUMERIC) → DATE​

  • year: Year value.
  • month: Month value.
  • day: Day value.
  • hour: Hour value.
  • minute: Minute value.
  • second: Second value.
  • millisecond: Millisecond value.

Examples

TIMESTAMPTYPE example 
SELECT TIMESTAMPTYPE(2020,10,5,1,2,3,500)
-- 2020-10-05 01:02:03.500