UPDATE caicobs_rep SET obs_date=date_format(date_first,'%Y-%m-%d') WHERE obs_date='0000-00-00'

DONE