Tech
Forums
Jobs
Books
Events
Interviews
Live
More
Learn
Training
Career
Members
Videos
News
Blogs
Login
Sign Up
Ask Question
6
Reply
Get time based on time zone
Arvind Singh Baghel
Aug 11 2016 7:21 AM
342
Reply
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
Upload Source Code
Select only zip and rar file.
Post
Reset
Cancel
Answers (
6
)
Next Recommended Forum
Oracle Error: ORA-12154: TNS: could not resolve the connect
Why we use mongo db?