Date Format

[dmcinnis]

How do i get the date value out of mysql (format 0000-00-00) to a string "Month, Day Year")

[Anon]

i use this, youll want to use something similar
$date = strtotime(substr($date,5,2).'/'.
substr($date,8,2).'/'.
substr($date,0,4).' '.
substr($date,11,5));
$date = date("M j, Y, g:i A", $date);

[dmcinnis]

That worked great. Thanks

[Anon]

it suprises the heck out of me, that this does not work for me; it gives me 1969 date.

[Anon]

The script work up very well, may be u take the system date.

[Anon]

I follow the script that u sended but i found some error.
This is the script that i insert

$datum = strtotime(substr($datum,5,2).'/'.
substr($datum,8,2).'/'.
substr($datum,0,4).' '.
substr($datum,11,5));
$datum = date("M j, Y, g:i A", $datum);

If i send this event for 1 to 1 person, this script is process well, but after send this date for 1 to many, then this script is taking the mySql system date --31 Dec 1969.

How to correct this method and allow the date display well?

Thanks for help

thanks & regard,
vennly

[Anon]

im not sure i understand your question.

this was a pretty old post anyway, you should now be able to use:

$datum = date("M j, Y, g:i A", strtotime($datum));

[Anon]

it's great, thanks