update of date column keeping HH:MM:SS
843389May 27 2011 — edited May 27 2011I am using the query below to update another parition but I am loosing time asssociated with
the data. Can somebody show me how to keep the time and only modify YYYYMMDD part of
the date
update xxx.tab1 set create_date='20110522' where
create_date >= to_date('2011/01/14', 'yyyy/mm/dd') and
create_date < to_date('2011/01/15', 'yyyy/mm/dd');