CURRENT_TIMESTAMP
The niladic CURRENT_TIMESTAMP function has a data type of TIMESTAMP and returns the date and local time at which it is run.
Refer to the SET TIME ZONE statement for a further description of local time.
Display CURRENT_TIMESTAMP:
SELECT CURRENT_TIMESTAMP AS date_and_time; date_and_time ---------------------- 1998-03-31 07:41:21-08
SQL92 specifies some additional capabilities for CURRENT_TIMESTAMP:
The optional scale for CURRENT_TIMESTAMP, if specified, is an unsigned integer representing the number of digits in the optional seconds fraction of the time value represented by the function.