[rt-users] Time in hours
jesse at bestpractical.com
Fri Nov 18 14:48:12 EST 2005
> 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
More information about the RT-Users