note 34274 added to function.date
| From: | daniel at daniel-wiedemann dot de | Date: | Sun, 20 Jul 2003 22:13:58 +0000 |
| Subject: | note 34274 added to function.date | ||
| Groups: | php.notes | ||
| Request: | Send a blank email to php-notes+get-52429@lists.php.net to get a copy of this message | ||
I don't know if it helps someone but I wrote a lil function that converts the mySQL
"datetime" fieldtype into seconds.
I wanted to compare two dates(inclusiv time). For sure there exists a better way to, but I was too
decayed to look for it.
(sorry for my bad english, I'm from germany)
$datetime="2003-07-20 23:54:57" //somethin like that
function datetime2sec($datetime){
$years=$datetime['0'].$datetime['1']
.$datetime['2'].$datetime['3']*31536000;
$months=$datetime['5'].$datetime['6']*2678400;
$days=$datetime['8'].$datetime['9']*86400;
$hours=$datetime['11'].$datetime['12']*3600;
$minutes=$datetime['14'].$datetime['15']*60;
$seconds=$datetime['17'].$datetime['18'];
$insec=$years+$months+$days+$hours+$minutes+$seconds;
return $insec;
}
echo datetime2sec($datetime); //returns 20113572917
----
Manual Page -- http://www.php.net/manual/en/function.date.php
Edit Note -- http://master.php.net/manage/user-notes.php?action=edit+34274
Delete Note -- http://master.php.net/manage/user-notes.php?action=delete+34274&report=yes
Reject Note -- http://master.php.net/manage/user-notes.php?action=reject+34274&report=yes