I did my timetable in sqlplus. Quite surprised I have to travel over 15 hours to go there!!! what a trip! I have never made such a long flight in one day!
set head off feedb off
col z for a14
col y for a17
col x for a17 fold_a
alter session set nls_timestamp_tz_format=’DD. HH24:MI TZH:TZM’;
select
” z,
‘zurich-sf’ y, ‘sf-zurich’ x,
‘flight’ z,
substr(b-a+d-c,12,5) y,substr(f-e+h-g,12,5) x,
‘travel’ z,
substr(d-a,12,5) y,substr(h-f,12,5) x,
” z, ” y, ” x,
” z, ‘localtime’ y, ‘zurichtime’ x,
‘zurich dep. ‘ z,
a y, a at time zone ‘Europe/Zurich’ x,
‘atlanta arr.’ z,
b y, b at time zone ‘Europe/Zurich’ x,
‘atlanta dep.’ z,
c y, c at time zone ‘Europe/Zurich’ x,
‘SF arr. ‘ z,
d y, d at time zone ‘Europe/Zurich’ x,
‘SF dep. ‘ z,
e y, e at time zone ‘Europe/Zurich’ x,
‘atlanta arr.’ z,
f y, f at time zone ‘Europe/Zurich’ x,
‘atlanta dep.’ z,
g y, g at time zone ‘Europe/Zurich’ x,
‘zurich arr. ‘ z,
h y, h at time zone ‘Europe/Zurich’ x
from
( select
timestamp ‘2005-02-16 10:30:00 Europe/Zurich’ a,
timestamp ‘2005-02-16 14:55:00 US/East-Indiana’ b,
timestamp ‘2005-02-16 16:40:00 US/East-Indiana’ c,
timestamp ‘2005-02-16 18:29:00 US/Pacific-New’ d,
timestamp ‘2005-02-23 08:21:00 US/Pacific-New’ e,
timestamp ‘2005-02-23 15:44:00 US/East-Indiana’ f,
timestamp ‘2005-02-23 17:25:00 US/East-Indiana’ g,
timestamp ‘2005-02-24 08:30:00 Europe/Zurich’ h
from dual)
/
zurich-sf sf-zurich
flight 15:14 13:28
travel 16:59 15:09
localtime zurichtime
zurich dep. 16. 10:30 +01:00 16. 10:30 +01:00
atlanta arr. 16. 14:55 -05:00 16. 20:55 +01:00
atlanta dep. 16. 16:40 -05:00 16. 22:40 +01:00
SF arr. 16. 18:29 -08:00 17. 03:29 +01:00
SF dep. 23. 08:21 -08:00 23. 17:21 +01:00
atlanta arr. 23. 15:44 -05:00 23. 21:44 +01:00
atlanta dep. 23. 17:25 -05:00 23. 23:25 +01:00
zurich arr. 24. 08:30 +01:00 24. 08:30 +01:00
on my return trip on leave sf at 8:21am and arrive at 8:30am in zurich !