note 28458 added to function.substr
| From: | ellipse at optonline dot net | Date: | Tue, 14 Jan 2003 04:10:01 +0000 |
| Subject: | note 28458 added to function.substr | ||
| Groups: | php.notes | ||
| Request: | Send a blank email to php-notes+get-42095@lists.php.net to get a copy of this message | ||
Here is a handy function, at least to me it is, to convert mysql returned timestamp(14) data-type
into yyyy-mm-dd hh:mm:ss format:
function get_DateTime ($string)
{
$yyyy = substr($string, 0,4);
$month = substr($string, 4,2);
$dd = substr($string, 6,2);
$hh = substr($string, 8,2);
$mm = substr($string, 10,2);
$ss = substr($string, 12,2);
$ftime = "$yyyy-$month-$dd $hh:$mm:$ss";
return $ftime;
}
Pretty much self-explanatory.
--
http://www.php.net/manual/en/function.substr.php
http://master.php.net/manage/user-notes.php?action=edit+28458
http://master.php.net/manage/user-notes.php?action=delete+28458
http://master.php.net/manage/user-notes.php?action=reject+28458