mysql date field vs unix epoch in an int(10) field.

[Rolf Brusletto <rolf-list@triculture.com>]

*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



--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php