Manipulating a datetime variable into a simple date.

[Jeremy_H]

I have a cell in my MySQL table that is a datetime and looks like this: 2006-07-10 15:04:36

Lets say later I grab the value from this cell I assign it to a variable, like $date.

By using the following line of code:

<p>Your last order was on <?php echo($date);?>.</p>

I can output:

"Your last order was on 2006-07-10 15:04:36."

However, I would like to have a sentence that says:

"Your last order was on July 10th."

Is there I way in PHP to easily manipulate "2006-07-10 15:04:36" into "July 10th"?

Thanks

[Little_G]

Hi,

try:

<p>Your last order was on <?php echo date('F jS', strtotime($date));?>.</p>

Andrew

[Jeremy_H]

Completely awesome!

I had no idea there was such an elegant solution.

Works great, thanks so much!

[Little_G]

No problem!

Andrew