Skip to Main Content
Forums

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!

Date update problem

Kam__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

User_J188U

Reposted to the appropriate category now: https://community.oracle.com/tech/developers/discussion/4497048/oracle-bug-that-might-be-fixed-in-newer-version

Christian.Shay -Oracle

XE is not patched (and it would be a long time before the next major release). Can you use some other edition?

User_J188U

I can't run another edition and this is just a synthetic test, but I wanted to report the issue.

Answer

I am able to reproduce this on Windows as well, so I will see if there is a bug filed already and if not, I will file one.

Marked as Answer by User_J188U · Apr 11 2022
User_J188U

Thanks!

1 - 5

Post Details

Added on Jan 14 2022
8 comments
380 views