week function in teiid not returning expected value --------------------------------------------------- Key: TEIID-1841 URL: https://issues.jboss.org/browse/TEIID-1841 Project: Teiid Issue Type: Bug Affects Versions: 7.5 Environment: Teiid 7.5 running on java 1.6 openjdk on rhel5 Reporter: Graeme Gillies Assignee: Steven Hawkins One of our users of our teiid instance as reported that the week function (to determine which week of the year it is) operates in teiid a little different to how they expect. Teiid resets the week count to 1 on every 1st of January even though the day is not the 1st day of the week (Sunday in here). But Postgres will only resets the week count to 1 only on the 1st Monday of the year. The examples below compare the results return by teiid and Postgres: {noformat} # Teiid result: EngVDBR=> select week(parsedate('2011-01-01', 'yyyy-MM-dd')) AS Week; week ------ 1 (1 row) EngVDBR=> select week(parsedate('2011-01-02', 'yyyy-MM-dd')) AS Week; week ------ 2 (1 row) {noformat} {noformat} # Postgres result: postgres=> SELECT EXTRACT(WEEK FROM DATE '2011-01-01') AS Week; week ------ 52 (1 row) postgres=> SELECT EXTRACT(WEEK FROM DATE '2011-01-03') AS Week; week ------ 1 (1 row) {noformat} -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.jboss.org/secure/ContactAdministrators!default.jspa For more information on JIRA, see: http://www.atlassian.com/software/jira