[teiid-issues] [JBoss JIRA] (TEIID-1841) week function in teiid not returning expected value
Graeme Gillies (Created) (JIRA)
jira-events at lists.jboss.org
Mon Nov 21 01:49:40 EST 2011
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
More information about the teiid-issues
mailing list