[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:comment-tabpanel&focusedCommentId=13030969#comment-13030969 ] 

Steven Hawkins commented on TEIID-3282:
---------------------------------------

dayofweek is similarly affected.

h2 has undocumented iso_week and iso_day_of_week functions that can be used.

> 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)