recent memberships has timezone issues with oracle

XMLWordPrintable

    • Type: Bug
    • Resolution: Fixed
    • Priority: Minor
    • 2.5.31
    • Affects Version/s: None
    • Component/s: None
    • None

      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)

            Assignee:
            Chris Hyzer (upenn.edu)
            Reporter:
            Chris Hyzer (upenn.edu)
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Created:
              Updated:
              Resolved: