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 convert date format entered as "01-APR-22 05.55.12.481000 PM -04:00" into format (yyyy-mm-dd)

User_B6A9PMay 11 2022 — edited May 11 2022

We have a dataset which contains date format as like
Example like:
"01-APR-22 05.55.12.481000 PM -04:00"
"12/6/2019 09:34:56 PM"

we have to convert any format of varchar2 date field to a specific format like into (yyyy-mm-dd).

Comments
Post Details
Added on May 11 2022
2 comments
3,762 views