PostgreSQL make_time() Function

The PostgreSQL make_time() function creates a time from the given hour, minute, and second fields.

`make_time()` Syntax

Here is the syntax of the PostgreSQL make_time() function:

make_time(hour INT, minute INT, second DOUBLE PRECISION) -> TIME

Parameters

hour: Required. An integer indicating the hour.
minute: Required. An integer indicating the minute.
second: Required. A double-precision value indicating seconds.

Return value

The PostgreSQL make_time() function returns a time value created from the given hour, minute, and second fields.

`make_time()` Examples

This example shows the basic usage of the make_time() function.

SELECT make_time(20, 55, 25.517606);

    make_time
-----------------
 20:55:25.517606

On this page