Command Prompt, Inc.
CURRENT_TIME
Practical PostgreSQL
PrevNext

CURRENT_TIME

Name

CURRENT_TIME -- Returns the current time.

Synopsis

    CURRENT_TIME

Parameters

This function does not accept any parameters.

Results

time

The 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)
PrevHomeNext
CURRENT_DATEUpCURRENT_TIMESTAMP

Powered by Mammoth PostgreSQL
Copyright © 2000-2007 Command Prompt, Inc. All Rights Reserved. All trademarks property of their respective owners.