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!

EST TimeZone

S567Nov 22 2019 — edited Nov 25 2019

Team,

Version is oracle 11g.

I have a feild which is declared as varchar2 and have values like this '10/22/2019 3p EST' i am trying to convert it into this format '2019-10-22 17:00:00 EST'

Can you advise.

Comments
Post Details
Added on Nov 22 2019
15 comments
1,077 views