Date problems

[nylex]

I have a script to get all the fields from a database and print them to a page.. one of which is a date. Only problem is the date is printed like 2002-06-02 17:47:47. How do I format it to print Sunday 2nd June 2002 for example? I've tried:

$Date = odbc_result($Result, 2);
$ts = strtotime($Date);
$PostDate = date("l jS F Y", $ts);
print("$PostDate");

but this gives me Warning: unexpected error in date() in c:\program files\apache group\apache\htdocs\nc\news.php on line 37

Any help appreciated, thanx.

[pullez]

You could try:
$query="SELECT field1, field2 ,date_format(date, '%D/%M/%Y') as date from db";
I´m almost sure this method will work , though you should check for the correct formating of the date itself in '%D/%M/%Y' to get the desired output format.
Cheers.

[nylex]

I'll try that 🙂.

[nylex]

Nope, I get undefined function errors when I do that 🙁.

[pullez]

Can you post the $query?I will try to help you.Also consider that you date field must be of the date type in MYSQL lso in the example I posted the dabase field was also called date.

[Anon]

He isn't using MySQL, Jorge. DATE_FORMAT() is a MySQL function

[nylex]

Can you help Mike? Heh, sorry.

[nylex]

🙁