Hi all,
I use odb file with HSQLDB (1.8.0.10), with any version of OOo, and java
1.6.0_18. (Tested in 3.2RC5, and 3.1.1, and hsqldb19 on linux, and in 3.0.0
in in Vista(HU version:).
The queries gives wrong value, if I compare to my Kmail or paper calendar, on
linux with HU locale.
SELECT WEEK('2010-01-01') FROM "Table"gives 1 instead of 53
SELECT WEEK(CURRENT_DATE') FROM "Table" gives 7 instead of 6.
If I use in postgres:
SELECT EXTRACT(WEEK FROM TIMESTAMP '2010-01-01 00:00:00'); I get 53.
In MYSQL:
SELECT WEEK('2010-01-01') gives 0.
SELECT WEEK(CURRENT_DATE) gives 6.
In HSQLDB 2.0.0RC8, in cws hsqldb19 version:
SELECT EXTRACT( WEEK_OF_YEAR FROM CURRENT_DATE ) FROM "Table" gives 7.
The all HSQLDB gives wrong results, for this years week number.
What can I do?
Thanks,
Zoltan
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
