[teiid-issues] [JBoss JIRA] (TEIID-3282) inconsistencies with the week function

[Steven Hawkins (JIRA)]

Steven Hawkins created TEIID-3282:
-------------------------------------

             Summary: inconsistencies with the week function
                 Key: TEIID-3282
                 URL: https://issues.jboss.org/browse/TEIID-3282
             Project: Teiid
          Issue Type: Sub-task
          Components: Query Engine
            Reporter: Steven Hawkins
            Assignee: Steven Hawkins
             Fix For: 8.10


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.  So by default 

And there are still several others to verify



--
This message was sent by Atlassian JIRA
(v6.3.11#6341)