Details

    • Type: Sub-task
    • Status: Closed (View Workflow)
    • Priority: Major
    • Resolution: Done
    • Affects Version/s: None
    • Fix Version/s: 8.10
    • Component/s: Query Engine
    • Labels:
      None
    • Affects:
      Documentation (Ref Guide, User Guide, etc.), Release Notes

      Description

      For consistency we could enforce a standard iso behavior for the week function by default.

      For mysql there is the weekofyear function that matches the iso behavior.
      hsql uses iso by default
      oracle should use iw, not ww

      However:
      h2 uses the locale (the current teiid behavior)
      sqlserver/sybase you can use SET DATEFIRST to move the first day of the week to monday, but the return values are still not fully iso.

      And there are still several others to verify

        Gliffy Diagrams

          Attachments

            Activity

              People

              • Assignee:
                shawkins Steven Hawkins
                Reporter:
                shawkins Steven Hawkins
              • Votes:
                0 Vote for this issue
                Watchers:
                2 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: