oracle current_timestamp

CURRENT_TIMESTAMP returns the cyrrent system timestamp. You can also specify an optional precision argument to control the precision of the seconds in the time. Example: SELECT CURRENT_TIMESTAMP AS RESULT FROM DUAL; RESULT ————————– 05-SEP-05 01.24.11.968000 PM -4:00