mysql date format yyyymmdd

update signatures
set day_index_updated=(CURDATE()+0)
where id=39;