Converting Date Format (08/12/11 to August 12)

[sintax63]

I have two fields in my table called start_date and end_date. The date format for each is xx/xx/xx.

 

I know how to do something like:

if ($start_date_month == "8") { $start_month = "August"; }

 

So I can change the 1 or 2 digit months to names. What I'm not sure how to do is strip out both the month and day from the full xx/xx/xx format.

 

Any help would be much appreciated.

 

Thanks!

[Pikachu2000]

If you had stored the values in the proper DATE or DATETIME type field, this would be very easy. I hope it isn't too late to change them to the right format.

[Maq]

If not ^, something like this:

echo date("F d", strtotime("08/12/11"));

 

Check out the manual - date.

[TeNDoLLA]

Or using php's DateTime class.

 

$date = '08/12/11';
$date = DateTime::createFromFormat('m/d/y', $date);
echo $date->format('F d');

[sintax63]

If you had stored the values in the proper DATE or DATETIME type field, this would be very easy. I hope it isn't too late to change them to the right format.

 

I wish it was possible. This is how I store dates / date time in my personal coding but I'm getting these values from a CSV file that I'm importing into phpMyAdmin.

[sintax63]

If not ^, something like this:

echo date("F d", strtotime("08/12/11"));

 

Check out the manual - date.

 

This did the trick! Thank you so much for the insanely quick help.

[Psycho]

If you had stored the values in the proper DATE or DATETIME type field, this would be very easy. I hope it isn't too late to change them to the right format.

 

I wish it was possible. This is how I store dates / date time in my personal coding but I'm getting these values from a CSV file that I'm importing into phpMyAdmin.

So, convert the values to proper dates when putting them in the database instead of storing them as strings. Perhaps you are too young to remember the significance of Y2K