select to_char(date_column,'YYYY-MM-DD') from table;
UPDATE T_name set column_name where = condition ;