Guest User

Untitled

a guest
Apr 24th, 2018
76
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.85 KB | None | 0 0
  1. SELECT TO_DATE('5/20/2018 10:05:00 PM','mm/dd/yyyy hh:mi:ss am'),
  2. TO_DATE('5/20/2018 10:05:00 PM','mm/dd/yyyy hh:mi:ss am')
  3. - 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
  4. from dual
  5. UNION
  6. SELECT TO_DATE('5/24/2018 11:35:00 PM','mm/dd/yyyy hh:mi:ss am'),
  7. TO_DATE('5/24/2018 11:35:00 PM','mm/dd/yyyy hh:mi:ss am')
  8. - 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
  9. from dual
  10.  
  11. Date date converting to Greenwich time zone
  12. 5/20/2018 10:05:00 PM 5/20/2018 6:05:00 PM --> hour difference 4 hours
  13. 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