Change date format from MySQL

[MartinH]

Hi.

I am getting a date from a MySQL with a 'select' statement. The date is received in this format: 'yyyy-mm-dd'. I will like to change the format to 'd. mmm yyy' (like 26. feb. 2003) before posting it to the screen with an 'echo' statement.

Any suggestions ??

Martin

[Dedix]

You'll need the date() function

www.php.net/date

But i suggest you to store date in unix timestamp format instead.

[GoSharks]

you can format it as you extract it from mysql also,
scroll down to "date_format"

[MartinH]

Thanks!

I have got GoSharks suggestion to work.