Returns the current date and time.
CURRENT_TIMESTAMP
This function does not accept parameters.
timestamp
The 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)
..................Content has been hidden....................
You can't read the all page of ebook, please click
here login for view all page.