I've noticed that in HSQLDB the first day of the week is always sunday, regardless of the JVM locale.
This applies to the function DAYOFWEEK and also to TRUNC when using the WW option.
Is there a way to change this behavior?
If not, I think the default behavior should be changed. In fact according to ISO standards the first day of week is monday.