#356 Supported date extraction function mismatch

[Anders Storsveen]

According to the table 10.1, hsqldb supports 'IW':

Week of year (1-52 or 1-53) based on the ISO standard. Week starts on Monday. The first week may start near the end of previous year.

However, when actually trying to use it I get the following:
"interval qualifier missing or not valid: IW"

'WW' works, but isn't what I need.

[Anders Storsveen]

I'm using it in TRUNC while under Oracle-compability mode, if that matters.

[Fred Toussi]

The 'IW' parameter is supported for TO_CHAR. What is the result of applying TRUNC with 'IW' ?

[Fred Toussi]

I have committed support for 'IW'. You can checkout from SVN base/trunc and test.