January 2002
Intermediate to advanced
640 pages
16h 39m
English
Returns the current date and time.
CURRENT_TIMESTAMP
This function does not accept parameters.
timestampThe current date and the current time. The return data type is timestamp.
Use the CURRENT_TIMESTAMP function to retrieve the current date and
time in a data type of timestamp.
The following example displays the result of a call to CURRENT_TIMESTAMP:
testdb=# SELECT CURRENT_TIMESTAMP AS date_and_time;
date_and_time
----------------------
2001-09-04 19:48:21-08
(1 row)