a date column, with timestamp..how to remove timestamp
760650Mar 17 2010 — edited Mar 17 2010Hi,
I have a table name CATCH, with one of its fieldnamed DATE, using DATE datatype.
The date format incudes timestamp,can anyone help me how to remove the timestamp part.
I only want the date part only. I have tried this:
Update CATCH set DATE=to_char(date,'DD-MON-YYYY');
but the result of all the date inside the table still having timestamp.
then i use this:
Update CATCH set DATE=to_date(date,'DD-MON-YYYY');
and the result still the same.
Can anyone advice on this? pls.
Thanks