Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

how to get local time based on time zone

user10447332Nov 23 2016 — edited Nov 23 2016

i need query to get local time value based on time zone. if user log in to application in Australia then  my query should give  austrelia local time,if user log into application in USA then it should give usa local time

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 21 2016
Added on Nov 23 2016
8 comments
1,433 views