Menu

#7 Database querying in UTC time.

Next_Release
open
Database (4)
8
2003-02-12
2003-01-22
Ian Duffy
No

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.

Discussion

  • Ian Duffy

    Ian Duffy - 2003-01-22
    • summary: Do all database querying in UTC time. --> Database querying in UTC time.
     
  • Ian Duffy

    Ian Duffy - 2003-01-22

    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.

     
  • Ian Duffy

    Ian Duffy - 2003-02-12
    • priority: 5 --> 8
     

Log in to post a comment.

Want the latest updates on software, tech news, and AI?
Get latest updates about software, tech news, and AI from SourceForge directly in your inbox once a month.