note 30629 added to ref.datetime
| From: | you at rack1 dot php dot net | Date: | Mon, 24 Mar 2003 13:17:51 +0000 |
| Subject: | note 30629 added to ref.datetime | ||
| Groups: | php.notes | ||
| Request: | Send a blank email to php-notes+get-45733@lists.php.net to get a copy of this message | ||
EXCEL DATES TO UNIX TIMESTAMPS
----------------------------
I get a lot of dates which are sent to me in those dastardly Excel spreadsheet things. For example,
the date 15 April 1976, Excel stores as 27865.
I convert these to UNIX timestamps using the little function below.
<?
function xl2timestamp($xl_date)
{
$timestamp = ($xl - 25569) * 86400;
return $timestamp;
}
?>
--
http://www.php.net/manual/en/ref.datetime.php
http://master.php.net/manage/user-notes.php?action=edit+30629
http://master.php.net/manage/user-notes.php?action=delete+30629
http://master.php.net/manage/user-notes.php?action=reject+30629