I have a table that keeps date
and hour
data as string. I added two fields date2
and hour2
in order to convert and save current string instead of varchar. Date format is dd.mm.YYYY
. I want to convert that string to date format and keep it in corresponding column for each row.
I have read "how to convert a string to date in mysql?" tried to query the following statement:
UPDATE `rawdata` SET `date2` = STR_TO_DATE(`date`, '%Y-%m-%d')
but I still see NULL
values in the date2
column. Nothing is updated.