note 21491 deleted from function.mktime by sniper
| From: | sniper@php.net | Date: | Tue, 04 Nov 2003 13:11:50 +0000 |
| Subject: | note 21491 deleted from function.mktime by sniper | ||
| References: | 1 | Groups: | php.notes |
| Request: | Send a blank email to php-notes+get-59883@lists.php.net to get a copy of this message | ||
Note Submitter: kris
----
function to convert a mySQL DateTime field to a Unix Timestamp (add error checking as necessary):
function unixTimeStampFromSQLDateTime($strSQLDateTime){
$arrDateTime = explode(" ", $strSQLDateTime);
$arrDate = explode("-", $arrDateTime[0]);
$arrTime = explode(":", $arrDateTime[1]);
return mktime($arrTime[0], $arrTime[1], $arrTime[2], $arrDate[1], $arrDate[2],
$arrDate[0]);
}