Hi All,

I am trying to update a date column ina table with following query and i get this error
"ORA-01841:(full) year must be between -4713 and +9999, and not be 0."
please help,

the query that i am executing is

update temp_ts
set st_time = decode(start_time,null, to_date(trunc(rk_date) || ' 8:00:00 AM','dd-mon-yyyy hh:mi:ss am'),to_date(trunc(st_time) || ' 8:00:00 AM','dd-mon-yyyy hh:mi:ss am')),
it_time = decode(it_time,null,to_date(trunc(rk_date) || ' 8:00:00 AM','dd-mon-yyyy hh:mi:ss am'),to_date(trunc(it_time) || ' 8:00:00 AM','dd-mon-yyyy hh:mi:ss am'))
where hours = 0 and ak_time = 0

any help is appreciated,

Thank You