Displaying date!

[cody44]

Having set up some info in my database I wanted to display the date the information was posted. Entering the data into the database the date displays in the format yyyy-mm--dd. How does one go about changing this to show dd-mm-yyyy or even something like 9-sept-05 ?

All help appreciated.

[devinemke]

are you using mySQL? if so read up on Date and Time Functions.

[cody44]

devinemke wrote:

are you using mySQL? if so read up on Date and Time Functions.

Thanks devinemke.............but did read up last week and I think I read too deep into it.

[devinemke]

specifically, read about the DATE_FORMAT() function.