Richard Zowalla created OPENJPA-3042:
----------------------------------------

             Summary: In-memory EXTRACT(WEEK) returns the day of the week
                 Key: OPENJPA-3042
                 URL: https://issues.apache.org/jira/browse/OPENJPA-3042
             Project: OpenJPA
          Issue Type: Sub-task
            Reporter: Richard Zowalla
            Assignee: Richard Zowalla


When EXTRACT(WEEK) is evaluated in memory, {{DateTimeExtractField.WEEK}} is 
mapped to {{ChronoField.ALIGNED_DAY_OF_WEEK_IN_YEAR}}, which is a day-of-week 
value (1 to 7), not the ISO week of the year. It should use 
{{IsoFields.WEEK_OF_WEEK_BASED_YEAR}}, matching the SQL side (OPENJPA-3037). 
Found while testing OPENJPA-3029.



--
This message was sent by Atlassian Jira
(v10.3.26#10030026)

Reply via email to