Uploaded image for project: 'Grouper'
  1. Grouper
  2. GRP-2838

recent memberships has timezone issues with oracle

    XMLWordPrintable

Details

    • Bug
    • Resolution: Fixed
    • Minor
    • 2.5.31
    • None
    • None
    • None

    Description

      In oracle, "recent memberships" might be up to 24 hours off depending on what timezone you are in.  you can fix this pre 2.5.30, edit the loader job query for recent memberships and change

       

      FROM:

      sysdate

       

      TO:

      cast(current_timestamp at time zone 'UTC' as date)

      Attachments

        Activity

          People

            chris.hyzer@at.internet2.edu Chris Hyzer (upenn.edu)
            chris.hyzer@at.internet2.edu Chris Hyzer (upenn.edu)
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: