CURRENT_TIMESTAMP SQL - Functions CURRENT_TIMESTAMP Returns the current date and time 1998-04-15 CURRENT_TIMESTAMP 1998-04-15 None. 1998-04-15 timestamp Returns "today" and "now". 1998-04-15 The niladic CURRENT_TIMESTAMP function has a data type of TIMESTAMP and returns the date and local time at which it is run. 1998-04-15 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 1998-04-15 SQL92 specifies some additional capabilities for CURRENT_TIMESTAMP: CURRENT_TIMESTAMP [ (scale) ] 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.