[CAY-2700] Standardize date[time] String representation in Cayenne expressions to be ISO8601

• Type: Improvement
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Fix Version/s: 5.0-M2
• Assignee: Unassigned
• Reporter: Andrus Adamchik
• Created: 09/Mar/21 06:37
• Updated: 09/Aug/24 10:18

Description

We need to standardize date[time] String representation in Cayenne expressions to be ISO8601.

Some background ... When parsing Cayenne expressions we do not attempt any type conversion of parameter values. This is usually not a problem for Cayenne users, as they can pass parameters already converted to a need type (e.g. LocalDateTime). However this is an issue for frameworks like Agrest that can not do proper parameter conversion as they are not aware of the left-hand side of an expression matched with the parameter.

So let's implement a more robust conversion inside the Cayenne stack. We can probably do it right in the ExtendedType. E.g. ExtendedType for String can do a ISO-8601 String to date[time] conversion based on the passed JDBC type.