note 80470 deleted from function.mktime by derick
| From: | derick@php.net | Date: | Sat, 26 Jul 2008 10:06:28 +0000 |
| Subject: | note 80470 deleted from function.mktime by derick | ||
| References: | 1 | Groups: | php.notes |
| Request: | Send a blank email to php-notes+get-142775@lists.php.net to get a copy of this message | ||
Note Submitter: Tiago Valdo
----
Taking a sample from a fellow poster a bit up, I've made this quite simple MYSQL date to
timestamp which will convert both date or date/time fields.
<?php
function MySQLtoTimestamp($mysqlDate) {
if (strlen($mysqlDate) > 10) {
list($year, $month, $day_time) = explode('-', $mysqlDate);
list($day, $time) = explode(" ", $day_time);
list($hour, $minute, $second) = explode(":", $time);
$ts = mktime($hour, $minute, $second, $month, $day, $year);
} else {
list($year, $month, $day) = explode('-', $mysqlDate);
$ts = mktime(0, 0, 0, $month, $day, $year);
}
return $ts;
}
?>