Skip to content
  1. Feb 15, 2008
  2. Feb 08, 2008
  3. Feb 03, 2008
    • Karen Stevenson's avatar
      Getting rid of offsets!! Alter query code to cast ISO and UNIX dates to native... · 3dddd854
      Karen Stevenson authored
      Getting rid of offsets!! Alter query code to cast ISO and UNIX dates to native datetimes and do timezone conversion in the database. Much faster and more accurate.
      
      This will mean this version of the code will not work for databases that are not able to do native timezone conversion, but even inexpensive shared hosts will probably have the MYSQL database timezone tables installed, and PostgreSQL has good timezone handling enabled by default.
      
      The MYSQL timezone conversion code should be accurate, the PostgreSQL code looks right from the documentation but needs to be verified.
      
      The offset fields can now be dropped from the Date fields since we only need the timezone name to do the conversion.
      
      I probably missed some places that need to be adjusted for this change, but this should get most of the necessary fixes in place.
      3dddd854
  4. Jan 23, 2008
  5. Dec 17, 2007
  6. Dec 03, 2007
  7. Jul 28, 2007