following format: date("F, d, Y"); ex: May, 27, 2008, now the problem
is that I want to change that field into mySQL date field as well as
convert my older dates into MySQL date format i-e Y-m-d (2007-08-06).
Thanks in Advance
Raja
Moderator: General Moderators
Code: Select all
UPDATE table_name SET new_date_column = STR_TO_DATE(old_date_column,'%M, %d, %Y');