EXTRACT(WEEK) is the ISO-8601 week
EXTRACT(WEEK FROM …) evaluated in memory, for example over a candidate collection, returned the day of the week instead of the week of the year.
It now returns the ISO-8601 week, so 2023-12-31 is in week 52 and 2021-01-03 in week 53.
On H2 the function is rendered as EXTRACT(ISO_WEEK FROM …), because H2 numbers a plain WEEK by the week definition of the JVM default locale.
In memory, java.util.Date, java.util.Calendar and java.time.Instant values are now accepted by EXTRACT and are read in the default time zone (a calendar in its own time zone), and EXTRACT of null is null.
DateTimeExtractField.getEquivalent() is deprecated and returns null for QUARTER and WEEK, which have no ChronoField.
Use getTemporalField() instead.