Arvind Singh

Arvind Singh

  • 322
  • 5.7k
  • 777.9k

Get time based on time zone

Aug 11 2016 7:21 AM
Hi 
i am fetching date and time in oracle using below query  
time zone is UK 
SELECT FROM_TZ(sys_extract_utc(systimestamp),'UTC') AT TIME ZONE ( '+00:00' ) FROM DUAL; 
 
but i am getting wrong time. plz help 

Answers (6)