timestamp formating ?

[Anon]

Ok I need to format a timestamp pulled from MySQL, I used the following to format standard datetime fields and it worked fine.

$f_date = date("d-M-Y", strtotime($mydate));

it produces this error on formating the Timstamp field:

Warning: unexpected error in date() in C:\Development\intranet\admin\econtent.php on line 103

[Anon]

Well, I am sure there is a far easier way to do this with a built in function but hav'nt found it yet.
Here is a function I wrote which should do the same thing.

function f_timestamp($ts_in) {
$et = $ts_in;
$eY = substr($et,0, 4);
$eD = substr($et, 4, 2);
$eM = substr($et, 6, 2);
$eT1 = substr($et, 8, 2);
$eT2 = substr($et, 10, 2);
$eT3 = substr($et, 12, 2);
$et2 = $eY."-".$eD."-".$eM." ".$eT1.":".$eT2.":".$eT3;
$ts_out = date("d-M-Y", strtotime($et2));
echo $ts_out;
}

f_timestamp($mytimestring);

[Anon]

strtotime() probably didn't work because MySQL timestamps don't look much like any sort of date format that humans use.

You could use MySQL's Unix Timestamp function to get MySQL to make the conversion before returning the result; or a more compact way for PHP to do what you give would be

list($eY, $eD, $eM, $eT1, $eT2, $eT3) = sscanf($ts_in, '%4s%2s%2s%2s%2s%2s');
$ts_out=date('d-M-Y',mktime(0,0,0,$eM,$eD,$eY));