Oracle Time Zone

Select Sysdate from dual;
Select Systimestamp from dual;
Select Localtimestamp from dual;
Select Current_timestamp from dual;
Select Dbtimezone from dual;
Select Sessiontimezone from dual;

Select To_timestamp (' 2015-11-06 10:35:00 ', ' yyyy.mm.dd hh24:mi:ss ') from dual;
Select To_char (sysdate, ' yyyy.mm.dd hh24:mi:ss ') from dual;

Systimestamp The current time and time zone of the database server;

Localtimestamp client current time, not including time zone;

Current_timestamp the client's current time zone, which contains the client's time zone.

Oracle Time Zone