Skip to Main Content
Forums

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!

unable to convert the date field with time value to another timezone

$a!Sep 17 2018 — edited Sep 19 2018

Hi All,

I have my database network working in US/Eastern and the session I work in is Asia/Calcutta

pastedImage_0.png

Now, I have a date variable with some time and I want to get the respective value in the Asia/Calcutta timezone. I tried using cast and at time zone but I am unable to convert.

When I am using to_timestamp or cast functions they are simply considering the date with 12:00:00 and appending the new timezone value. That way I am missing the time value and there by getting the target date.

Eg:

pastedImage_3.png

While the actual time here in Asia/Calcutta is 17-Sep-2018 11:30 PM (some minutes here or there).

Is there a way to get the date value converted into the target timezone with the time also changed?

Kindly help.
This post has been answered by cormaco on Sep 17 2018
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 15 2018
Added on Sep 17 2018
9 comments
2,163 views