[SOLVED] Formatting a MySQL DB Timestamp on Echo

[OLG]

Hey guys,

 

time for me to be the noob now (as if that ever changed )

 

How would i go about formatting a timestamp like this from my MYSQL DB: 20070720111445

 

Into something nice and coherent such as: 20th of July 2007 HH:MM

 

Thank you,

 

Adam

[pocobueno1388]

You can either use the date() function.

www.php.net/date

 

Or you could use mysql's TIME_FORMAT function.

http://dev.mysql.com/doc/refman/4.1/en/date-and-time-functions.html

[gerkintrigg]

use date("d/m/Y",$timestamp);

 

look up "date PHP" in google... it has great links there. the d, m and Y can all be changed depending on the way you want to display the stuff.

 

hope it helps.

 

Cheers

[OLG]

Yes, i did know about the date format, but it keeps throwing out the wrong dates

 

I don't think its 2038 quite yet

[per1os]

Yes, i did know about the date format, but it keeps throwing out the wrong dates

 

I don't think its 2038 quite yet

 

What format is your timestamp in? Is it a unix timestamp?

 

If not look into www.php.net/strtotime

 

The issue lies within the timestamp, not the date function.

[OLG]

I'm not actually sure, i've just changed over to a Plesk Server (8.1.1, using Virtuozzo, so i guess not) and am now having problems (its an older MYSQL Version)

 

its arranged YYYYMMDDHHMMSS (Year, Month, Day, Hour, Minute, Seconds)

 

strtotime returns -1, so i guess its telling me to go blow a fish right?

 

I might just do a regular expression match, use some backreferences and re-organise it and just leave it like that, can't be assed to screw around with a timestamp.