At 22:25 -0700 3/12/03, Jason Brothers wrote:
>I apologize if this topic has been discussed in the past. I am just looking
>for feedback whether to use Datetime or Unixtime (32 bit Int) for my
>timestamps. From what I can tell here are the advantages and disavantages
>of each method:
>Unixtime (stored as 32bit int):
>- should require less CPU cycles to process
>- required only 4 bytes of storage.
>- a lot of 3rd party tools (interfacing thru ODBC) do not have native
>functions for Unixtime (eg. Crystal Reports, Excel).
>- Unixtime may confuse end-users.
>- 3rd party tools have native functions for Datetime
>- Easier to understand for end-users
>- Likely cause more overhead to process (for queries and inserts).
>- Requires 8 bytes of storage.
>At the moment I am on the fence and would appriciate any feedback or
>experience that anyone has.
Don't forget to consider the range of each type. TIMESTAMP goes from
1970 to mid-2037. DATETIME goes from year 1000 to year 9999.