MySQL help (with possible php I think) - Date format

Butters · 24 Oct 2007 at 12:17

Hi All,

I have a table with a field called date with a type of timestamp. The attribute of this is "on update current_timestamp" and the default is "current_timestamp"

When I use this field in a webpage it displays as YYYY-MM-DD 00:00:00

How can I change it so that it shows just the date in this fashion

22 October 2007 (for example)

Thanks

SiriusB · 24 Oct 2007 at 12:26

Go look up PHPs date function.

And wrong forum.

Sic · 24 Oct 2007 at 12:26

whilst you're there, look at mysql's DATE_FORMAT()

MarcLister · 24 Oct 2007 at 12:30

SiriusB said:
And wrong forum.

I've reported it and hopefully a passing don will move this to the programming forum soon.

Butters · 24 Oct 2007 at 12:35

Opps, my bad! Could have sworn I was in Programming!

Thanks gents

MarcLister · 24 Oct 2007 at 12:45

No probs.

Don't do it again.