Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT TO_DATE('5/20/2018 10:05:00 PM','mm/dd/yyyy hh:mi:ss am'),
- TO_DATE('5/20/2018 10:05:00 PM','mm/dd/yyyy hh:mi:ss am')
- - extract(TIMEZONE_HOUR from from_tz (TO_TIMESTAMP('5/20/2018 10:05:00 PM','mm/dd/yyyy hh:mi:ss am') ,'GMT' ) at time zone 'Europe/Moscow')/24 deptime_GRINICH
- from dual
- UNION
- SELECT TO_DATE('5/24/2018 11:35:00 PM','mm/dd/yyyy hh:mi:ss am'),
- TO_DATE('5/24/2018 11:35:00 PM','mm/dd/yyyy hh:mi:ss am')
- - extract(TIMEZONE_HOUR from from_tz (TO_TIMESTAMP('5/24/2018 11:35:00 PM','mm/dd/yyyy hh:mi:ss am') ,'GMT' ) at time zone 'Europe/Moscow')/24 deptime_GRINICH
- from dual
- Date date converting to Greenwich time zone
- 5/20/2018 10:05:00 PM 5/20/2018 6:05:00 PM --> hour difference 4 hours
- 5/24/2018 7:35:00 PM 5/24/2018 3:35:00 PM --> hour difference 4 hours
Add Comment
Please, Sign In to add comment