[rt-users] Query in script not working
Stephen Turner
sturner at MIT.EDU
Mon Feb 25 14:24:19 EST 2008
Quoting Mathew Snyder <mathew.snyder at gmail.com>:
> I've got the dates working. However, the tickets retrieved are still
> based on
> the day starting at 05:00:00 and ending the following morning at the
> same time.
> How can I tell it to only return tickets from between 00:00:00 and 23:59:00?
>
> Mathew
>
>
You are actually getting the tickets you want - the dates are stored in the
database as GMT and so appear different by 5 hours from what you see on the
screen. It looks a bit strange, but it works fine.
BTW - what was the problem that you fixed with the dates?
Steve
More information about the rt-users
mailing list