Postgres module

timestamp_from_civil

procedure · 1 overloadsince 0.27.0Source

The instant at that wall-clock reading, taken as UTC.

timestamp_from_civil :: (
    year: s64,
    month: s64,
    day: s64,
    hour := 0,
    minute := 0,
    second := 0,
    microsecond := 0
) -> Timestamp

The instant at that wall-clock reading, taken as UTC.

Parameters

year: s64
the year; 0 is 1 BC.
month: s64
1 to 12.
day: s64
the day of the month, from 1.
hour := 0
0 to 23.
minute := 0
0 to 59.
second := 0
0 to 59.
microsecond := 0
0 to 999999.

Returns

See also