My SQL time stamp format

[Anon]

Any one got an easy way of converting the MySQL time stamp '20001219160926'

to a nice format such as Tuesday 19th December 4:09pm ?

I tried the date() statement with out much success!

Thanks and merry xmas!

[Anon]

If it's any help (it took me a while to notice), the mysql time stamp format is "yyyymmddhhmmss".

Then you can break that up with substr() into a date("m/d/y", mktime(....)); statement.

[Anon]

Use the MySQL-build-in functionality!!
select .., .., DATE_FORMAT(MY_TIMESTAMP,'%d. %m. %Y') AS FORMATED_STRING ..

then you can read out the FORMATED_STRING.
Look at the mySQL-manual at "DATE_FORMAT".
Syntax: DATE_FORMAT(TIMESTAMP,FORMAT)

[Anon]

Thanks!

in the end I used ;

$year = substr($lastupdated, 0, 4) ;
$month = substr($lastupdated, 4, 2) ;
$day = substr($lastupdated, 6, 2) ;
$hour = substr($lastupdated, 8, 2) ;
$minute = substr($lastupdated, 10, 2) ;
$second = substr($lastupdated, 12, 2) ;

$make = mktime($hour, $minute, $second, $month, $day, $year) ;
$display = date("l jS F Y - g:ia", $make) ;

Thanks All!

[the_v_o_i_d]

If it is any help to anyone this could be done like this too ...

function Mod_Date($timestamp) {

$year = substr($timestamp, 0, 4);
$month = substr($timestamp, 4, 2);
$day = substr($timestamp, 6, 2);

$mod_time = sprintf(\"%s/%s/%s\", $month, $day, $year);
return $mod_time;

}

-hk