Mega Code Archive

 

Categories / Oracle PLSQL / Date Timezone

 

Select current_timestamp from dual to see the session time

SQL> select current_timestamp from dual; CURRENT_TIMESTAMP ------------------------------------------------------ 26-OCT-09 10.31.37.075000 AM -06:00 1 row selected. SQL>