Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback, please email oracle-forums_moderators_us@oracle.com

timezone conversion

Vicky007May 29 2020 — edited May 29 2020

Hi ,

Any idea how we can parse this format of timezone : 2018-04-16T16:55:52+0530

I tried multiple options but no luck. I am looking for timestamp format expression which can be used in SQLLDR. i tried 'YYYY-MM-DD"T"HH24MISS'  and various combination but no luck...

Thanks

Comments
Post Details
Added on May 29 2020
6 comments
169 views