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

[Steven Hawkins (JIRA)]

     [ https://issues.jboss.org/browse/TEIID-3282?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Steven Hawkins resolved TEIID-3282.
-----------------------------------
    Resolution: Done


Addressed the inconsistencies with the week function as much as possible.  Teiid will default to the iso 8601 calculation for consistency and sources were updated to match.  The dayOfWeek function was made to always return 1=sunday - 7=saturday regardless as that is part of the odbc standard and is matched by most sources - that is a slight change from the behavior that attempt to match the postgresql extract dow logic previous when the iso8601Week property was set.

We could introduce specific iso_year and iso_day_of_week functions to further allow iso calculations.

> 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. 
> And there are still several others to verify



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