Mega Code Archive

 

Categories / Oracle PLSQL / Date Timezone

 

CURRENT_TIMESTAMP()

SQL> SQL> --CURRENT_TIMESTAMP(): containing the current session time along with the session time zone. SQL> SQL> SELECT CURRENT_TIMESTAMP FROM dual; CURRENT_TIMESTAMP --------------------------------------------------------------------------- 16-SEP-06 08.35.05.062000 PM EST SQL>