Date from mysql and Y m D

Anon

I have a field in mysql database type date stores in fo as 0000-00-00 or year month day, i use the php date function to type to display in day name of mont any year. but get some weird results if have 2001-03-01 and use date("y-m-d",$fred[release_date])
I get 70-01-01 if I use "d-M-Y" i get 01-jan-1970
anyhelp appreciated
Mark

reagent

in your mysql query do
select unix_timestame(release_date) as time_stamp

then in code

print date("y-m-d", $fred["time_stamp"]);

date wants a unix timestamp as its second argument, so this will work for what you need.

Anon

Or do it in the query uising MySQL's DATE_FORMAT()

"SELECT DATE_FORMAT(datefield, '%y-%m-%d') as date from tablename";

Anon

Thanks for the tip... I have been looking around and scraching my head for months, not understanding why DATE_FORMAT wouldn't work for me.

And then I finally understud from you query that MySQL returns the column "datefield" as "DATE_FORMAT(datefield, '%y-%m-%d')" unless you add the "as date"... so simple, yet so frustrating for a sql novice like me.

Thanks,
Pat