Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Please ask technical questions in the appropriate category. Thank you!

Datatype conversion from Varchar2 to Timestamp/date with Data

JhilMay 17 2024

Dear Experts,

Source Database side datatype is varchar2 to store “date and Timestamp”

For e.g. : created_date varchar2(30), and Lastupdated_date varchar2(30)

We done same for theTarget Database and then migrated data to the target database.

Now we want convert the data type from Varchar2 to (date / timestamp) in target DB without affecting the existing data.

Thanks & Regards,

Jhil

Comments
Post Details
Added on May 17 2024
5 comments
120 views