note 34274 added to function.date

From: 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

« previous php.notes (#52429) next »