PostgreSQL 17.5
MAKE_TIME(hour, minute, second)Parameters
- hourinteger
- Hour from 0 to 23
- minuteinteger
- Minute from 0 to 59
- seconddouble precision
- Second, can be fractional
Return value
A time without time zone (time); values out of range cause an error
Examples
Time from parts
PostgreSQL 17.5
SELECT MAKE_TIME(12, 30, 45);Fractional seconds
PostgreSQL 17.5
SELECT MAKE_TIME(8, 15, 23.5);Details
A timestamp is built from parts by MAKE_TIMESTAMP(year, month, day, hour, min, sec).