note 45505 deleted from function.explode by tomsommer
| From: | tomsommer@php.net | Date: | Thu, 09 Sep 2004 20:27:51 +0000 |
| Subject: | note 45505 deleted from function.explode by tomsommer | ||
| References: | 1 | Groups: | php.notes |
| Request: | Send a blank email to php-notes+get-76356@lists.php.net to get a copy of this message | ||
Note Submitter: diligent
----
explode for date conversion
--------------------------
if you are having problems converting dates for display, entry and storage in mysql, try using
explode like this -
// format date for database (dd/mm/yyyy > yyyy-mm-dd)
$split = explode('/', $in_date);
$in_date = ($split[2].'-'.$split[1].'-'.$split[0]);
AND
// format date for display in HTML from DB (yyyy-mm-dd > dd/mm/yyyy)
$split = explode('-', $out_date);
$out_date = ($split[0].'/'.$split[1].'/'.$split[2]);