How to re-format datetime when searching?

turkraft / springfilter

Dynamically filter JPA entities and Mongo collections with a user-friendly query syntax. Seamless integration with Spring APIs. Star to support the project! ⭐️

https://turkraft.com/springfilter

221 stars 37 forks source link

How to re-format datetime when searching? #396

Closed MixueCN closed 2 months ago

MixueCN commented 2 months ago

The field createdDate is of timestamp type. When I pass the filter parameter as createdDate > '17-07-2024', I receive an SQL Error "date/time field value out of range: '17-07-2024'". I can make adjustments in version 2.1.5, but I'm unsure where to make changes for version 3. Thank you.

torshid commented 2 months ago

Conversions are handled by Spring's ConversionService in version 3.