Database querying in UTC time.
Status: Beta
Brought to you by:
duffian
Change query so that the query is run using UTC time
rather than local time...see example below.
For example:
If an alert occurs at 23:00:00 EST on 19 Jan 03, it will
be logged at 04:00:00 UTC on 20 Jan 03. If you go query
the database for 19 Jan 03, it will not show you the
alerts as it happened in the "future".
I think that this it could be beneficial for you to add a
feature to search in UTC time vs local system time.
Logged In: YES
user_id=529067
Rather than do all querying in UTC time, I will probably put in
a RadioButton group to allow the user to select between local
time and UTC time. This will give the program more flexibility.
This should be done by the time I get back from Chicago.