hey u hav add to_date function like this......
Update student_record_database
set date_of_birth = to_date(to_char('31/12/2000','dd/mm/yyyy'))
where rollno=122;
or use
Update student_record_database
set date_of_birth = (to_date('31/12/2000','dd/mm/yyyy'))
where rollno=122;
or this will definitly work
Update student_record_database
set date_of_birth = to_char(to_date('31/12/2000','dd/mm/yyyy'))
where rollno=122;</pre>