date

[JakesSA]

I have got dates stored in my db as a timestamp (8) as soon as the article has been added or created.

ie: 20030414

how do I get it to be 14 of April 2003.

Ive used substr() to break it down and then reconstruct it, but still I get the wrong answer.

// prints: 12 of June 1970 
echo date("j of F Y", "14042003");

Thanks

[cgraz]

Assuming you're using mysql, check out http://www.mysql.com/doc/en/Date_and_time_functions.html

search the page for DATE_FORMAT

Cgraz

[jpmoriarty]

the date function accepts a unix timestamp, ir the number of seconds that have elapsed since midnight 1st jan 1970 (date("U")). You're just giving it a date eith no separators...

you could use mktime(hour, minute, second, month, day, year) to convert your "timestamp" into a unix timestamp and then use that with date(format required,unix timestamp) to get the right answer.

ie break your "timestamp" down to $date['year'], $date['month'] and $date['day'], then do:

$timestamp = mktime (5,0,0,$date['month'],$date['day'],$date['year']);
echo date("j \o\f F Y", $timestamp);

[cahva]

As cgraz mentioned, look up the mysql date and time functions. Theres no need to handle the timestamp with complex date functions. You can get the right result with a query like this:

$query="SELECT DATE_FORMAT(date_field,'%d of %M %Y') as date_field FROM table";