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