Convert a date to mysql format

PHP
1

Hi,
I have a number of dates in a excel spreadsheet, in the format 17-Jul ( for this month), is there anyway for me to convert this to mysql format?

Thanks in advance.

2

If you are sure they are all for the current year (when the script is executed) this will work.


$date = '17-Jul';
$date = date('Y-m-d', strtotime($d . '-' . date('Y'))); //2010-07-17

However, if the cells are a date type and not plain text and you can edit the spreadsheet, you can probably change the date format in excel before you export.

3

thanks Cranial, thats perfect.