PostgreSQL LOCALTIME() Function

The PostgreSQL LOCALTIME() function returns the current time. This function returns the current time of the day as a 'HH:MM:SS.US' format.

Syntax

LOCALTIME(precision)

Note: Do not put parentheses () after the LOCALTIME function if the precision parameter is not specified.

Parameters

Return Value

Returns the current time as a 'HH:MM:SS.US' format.

Example 1:

The example below shows the usage of LOCALTIME() function.

SELECT LOCALTIME;
Result: '08:01:29.125744'

SELECT LOCALTIME(1);
Result: '08:01:29.1'

SELECT LOCALTIME(2);
Result: '08:01:29.13'

SELECT LOCALTIME(3);
Result: '08:01:29.126'

SELECT LOCALTIME(4);
Result: '08:01:29.1257'

Example 2:

Consider a database table called EmployeeLogin with the following records:

To insert a new record in this table, the following statement can be used.

INSERT INTO EmployeeLogin 
VALUES (6, 'Suresh', CURRENT_DATE, LOCALTIME(0));

-- see the result
SELECT * FROM EmployeeLogin;

This will produce a result similar to: