rajaboys Posted February 19, 2009 Share Posted February 19, 2009 I have a database in which the date is stored in varchar field in a 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 Link to comment https://forums.phpfreaks.com/topic/145871-mysql-varchar-to-date/ Share on other sites More sharing options...
PFMaBiSmAd Posted February 19, 2009 Share Posted February 19, 2009 http://dev.mysql.com/doc/refman/5.0/en/date-and-time-functions.html#function_str-to-date Link to comment https://forums.phpfreaks.com/topic/145871-mysql-varchar-to-date/#findComment-765933 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.