[rt-users] Time in hours

[Jesse Vincent]

> Shouldn't time fields really always be SQL datetimes so queries can be
> based on interval math?

When you're talking about a quantity of time instead of a point in time, 
you don't want a datetime.

Also, were I writing RT from scratch today, I'd use big integers and do
all my time in seconds since the epoch. SQL DATETIME fields are a really
nice idea. Until you start thinking about working in multiple timezones.
Or on multiple engines.



> --
>   Les Mikesell
>    les at futuresource.com
> 
> 

--