i want update date field in table. getting date value form mm/dd/yy i.e(05/06/13) format. want date convert y-m-d (i.e 2013-05-06) format , update it. used date_format date not updating .
update tablename set coldate = date_format(str_to_date(coldate,'%m/%d/%y'),'%y/%m/%d')
Comments
Post a Comment