Skip to Main Content

SQL & PL/SQL

Date update problem

Kam_oracle_apexJan 14 2022

Hi Friends
I have a table where 4 fields are created
att_day, att_month, att_year, attend_date
These att_day, att_month, att_year datatype is varchar2 and attend_date is date
att_day, att_month, att_year, attend_date
01 01 2022
02 02 2022
I want above varchar fileds data to be update in attend_date as date like 01/01/2022, 02/02/2022.
Please help how can i do this.
Regards
Kam

Comments
Post Details
Added on Jan 14 2022
8 comments
212 views