ORACLE CURRENT_TIMESTAMP()

오라클 CURRENT_TIMESTAMP()

 

CURRENT_TIMESTAMP(precision)

 

CURRENT_TIMESTAMP returns the current date and time in the session time zone, in a value of data type TIMESTAMP WITH TIME ZONE. The time zone offset reflects the current local time of SQL session. If you omit precision, then the default is 6. The difference between this function and LOCALTIMESTAMP is the CURRENT_TIMESTAMP returns a TIMESTAMP WITHE TIME ZONE value LOCALTIMESTAMP returns a TIMESTAMP value. 

 

In the optional argument, precision specifies the fractional second precision of the time value returned. 

 

SQL > SELECT SESSIONTIMEZONE, CURRENT_TIMESTAMP() FROM DUAL ;

   --> +09:00              2020/03/26 AM 10:46:57.662000 +09:00