January 2002
Intermediate to advanced
640 pages
16h 39m
English
Content preview from Practical PostgreSQLBecome an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
Start your free trial
Current_Time
Returns the current time.
Synopsis
CURRENT_TIME
Parameters
This function does not accept any parameters.
Results
timeThe current time. The return data type is
time.
Description
Use the CURRENT_TIME function to retrieve the current system-recorded
time in an object of data type TIME.
Examples
The following example retrieves the current time:
testdb=# SELECT CURRENT_TIME AS the_time;
the_time
----------
19:44:35
(1 row)