On Feb 6, 2008, at 7:37 AM, Steve Cochran wrote: > > Are all the dates in the DB stored in GMT? Looking to get some stats > out of RT, and have the following query to count all of the request > messages (and a negated one for the replies):
yes, RT stores dates as GMT and converts for display. -kevin _______________________________________________ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com