comparing time (related question)
| From: | Jackson Miller | Date: | Wed, 24 Apr 2002 15:37:41 +0000 |
| Subject: | comparing time (related question) | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-94409@lists.php.net to get a copy of this message | ||
When storing dates and times in databases is it better to store them as
UNIX timestamps or in one of the SQL date/time types?
I am working on an application that takes school attendance and has
homework assignments, so I am doing a fair amount of date work.
Currently I am storing everything as date time and referring to a day
with the UNIX timestamp for midnight of that day. I am able to do
everything I need to do with both formats, but I am wondering if there
is a performance issue at hand.
Thanks for any replies.
-Jackson