I need to split this up

[Anon]

Hey Everyone,

I have a timestamp coming out of a mysql database that looks like this when it is printed

20020321163021

I need a little script that will make this look like this

2002/03/21 16:30

Any one got any ideas?

[Anon]

Yes, how about checking substr() function...

Dmitriy

[Anon]

//the most obvious sulution is substr().

$timestamp = "20020321163021";

echo substr($timestamp,0,4).'/'.substr($timestamp,4,2).'/'.substr($timestamp,6,2).' '.substr($timestamp,8,2).':'.substr($timestamp,10,2);

// BUT... Here's a better solution:

//You could use mktime()...

$time = mktime (substr($timestamp,8,2), substr($timestamp,10,2), substr($timestamp,12,2), substr($timestamp,4,2), substr($timestamp,6,2), substr($timestamp,0,4));

//...and then use date() to print it out in ANY format!
// see http://us2.php.net/manual/en/function.date.php for more info.

date("Y/m/d H:i", $time);

[van__]

Be an SQL-uberMon...

$stmt = "SELECT DAYNAME(dateCol) as weekDay, DAYOFMONTH(dateCol) as date, MONTHNAME(dateCol) as monthString, MONTH(dateCol) as monthNum, YEAR(dateCol) as year, HOUR(dateCol) as hours, MINUTE(dateCol) as minutes, SECOND(dateCol) as seconds FROM myTable ORDER BY UNIX_TIMESTAMP(dateCol)";

which will give you something like:
weekday | date | monthString | monthNum | year
Thursday | 21 | March | 03 | 2002

[Anon]

Thanks guys, got it working for the most part (www.uidzer0.org) in development

Ben