Kbase P62724: SQL92 returns wrong week number if using WEEK function
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
08/04/2011 |
|
Status: Unverified
SYMPTOM(s):
SQL92 returns wrong week number if using to_char(date_field,'WW') or WEEK function
FACT(s) (Environment):
Progress 9.1D
OpenEdge 10.0A
Windows 32 Intel
CAUSE:
bug# OE00100007
FIX:
The week counter switches the same weekday as the first day of the year.
That is in 2003 on Wednesday and 2004 on Thursday.