SQL> update nsys_safezone_bbs set input_date= to_char('19-jan-03') where no=3; select * from tu_op_graph_temp where node_name='BISWAS1' and CALC_DATE=to_date('2006-04-26','yyyy-mm-dd') ;