Categories: Date/Time

TIMESTAMPTYPE

Constructs a TIMESTAMP from year, month, day, hour, minute, second, and optional sub-second precision (millisecond, microsecond, nanosecond).

Syntax

TIMESTAMPTYPE(year numeric, month numeric, day numeric, hour numeric, minute numeric, second numeric[, millisecond numeric][, microsecond numeric][, nanosecond numeric]) → TIMESTAMP

• year: Year value.
• month: Month value.
• day: Day value.
• hour: Hour value.
• minute: Minute value.
• second: Second value.
• millisecond (optional): Millisecond value.
• microsecond (optional): Microsecond value.
• nanosecond (optional): Nanosecond value.

Examples

TIMESTAMPTYPE example

SELECT TIMESTAMPTYPE(2025, 12, 12, 9, 15, 15)
-- 2025-12-12 09:15:15

SELECT TIMESTAMPTYPE(2025, 12, 12, 9, 15, 15, 123)
-- 2025-12-12 09:15:15.123

SELECT TIMESTAMPTYPE(2025, 12, 12, 9, 15, 15, 123, 456)
-- 2025-12-12 09:15:15.123456

SELECT TIMESTAMPTYPE(2025, 12, 12, 9, 15, 15, 123, 456, 789)
-- 2025-12-12 09:15:15.123456789

SELECT TIMESTAMPTYPE(2026, NULL, 18, 0, 0, 0)
-- null