Very useful information - thank you. Does anyone know of a site that may show a step by step process to do a date format conversion on a mysql db with PHP? I created a database about 3 years ago using varchar just to use a mm-dd-yyyy format and now I'm wishing I'd used the native mysql format of yyyy-mm-dd.
I'm posting to an older thread but am hopeful it still gets picked up. :-)
[QUOTE=NullPointer;869159]I would convert the date string to a timestamp and then use date() to format it however I want
$date = 'mm/dd/yyyy';
$timestamp = strtotime($date);