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!

ORA-01821: date format not recognized

Tony007Oct 11 2018 — edited Oct 11 2018

hi am geting error in this sql

update employee
set hireDate =  TO_DATE('MM/DD/YYYY','01/01/2100')

am in 11gR2

This post has been answered by BEDE on Oct 11 2018

Jump to Answer

Added on Oct 11 2018

7 comments

6,540 views