[rt-users] Time in hours

[Les Mikesell]

On Fri, 2005-11-18 at 13:48, Jesse Vincent wrote:
> 
> > 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.

The difference between datetimes should be an interval.

> 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.

SQL is supposed to do timezones.

> Or on multiple engines.

Do you mean things that are not really SQL? Why use them?

-- 
  Les Mikesell
    les at futuresource.com