Display mySQL Date

[kamy99]

Hi again:

A column in my db is Date. I insert to it through now() function.
It works just fine, however when I extract it from DB it shows something like this (mySQL time) 20020926083837.
I can't format it in my select statement as I'm using Select * from.... (or at least I don't know how!)

So basically I need to format it through php.

Ideas?

thanx
kamy

[bastien]

http://www.php.net/manual/en/function.date.php

[marcel]

you can do:
SELECT *, DATE_FORMAT(date_column, '%Y-%m-%d') as char_data FROM...

now you have a new column called : char_data

hope this helps
PM