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!

I'm getting a bad time with timezones. No implicit conversion from UTC to session timezone?

juliojgsJun 6 2024

Hi, this is oracle 19.

My timezone is GMT+2 , dbtimezone and sessionzone.

I'm getting a json with UTC dates in iso format strings. So , if they send me "2024-06-05T06:00:00Z" I want it inserted in my tables the same way as it would be to_date('2024-06-05 08:00', ‘YYYY-MM-DD HH24:MI’).

Why if I'm using get_timestamp it seems to ignore the Z and consider the date as 6:00 instead of 8:00 ?

I mean, if I take 6:00Z and put it into a timestamp variable, shouldn't it convert it directly to my session zone?

Added on Jun 6 2024

5 comments

886 views