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):
select Count(*) from Transactions, Tickets where (Transactions.Type =
'Correspond' and
Transactions.ObjectType = 'RT::Ticket' and
Transactions.ObjectId = Tickets.id and
Transactions.Creator
= Tickets.Creator and
Transactions.Created
>= '2008-02-05 00:00:00' and
Transactions.Created
<= '2008-02-05 23:59:59');
I've noticed that some things that happened on the 5th are actually
stored in the DB with a transaction.created date of the 6th. Looks
like a GMT conversion factor, but just wanted to confirm before I
convert my search params.
Steve
_______________________________________________
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
