Adding date in the Flexible query of Hybris

We can use the function TO_DATE() in the flexible query and pass in a date format to use as the second argument. For more information on TO_DATE() function, see here.

An example of how it can be used is the following:

select {PK} from {Order} where {MODIFIEDTIME}>= to_date('2020-01-29', 'YYYY-MM-DD')