mysql date field vs unix epoch in an int(10) field.
| From: | Rolf Brusletto | Date: | Sat, 10 May 2003 04:06:18 +0000 |
| Subject: | mysql date field vs unix epoch in an int(10) field. | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-27631@lists.php.net to get a copy of this message | ||
*This message was transferred with a trial version of CommuniGate(tm) Pro*
Howdy all,
I'm curious which would be faster... I have a need to save a date in mysql.
Option #1: Use a MySQL Date field "2003-05-09"
Option #2: Use a MySQL int(10) field with a unix epoch( time(); )
My question is, if I do a query, between two dates, which will be faster?
Anybody have comments?
Thanks in advance,
Rolf Brusletto
PHP / MySQL Coder
http://www.phpexamples.net