Flexible Search query date parameter
https://experts.hybris.com/questions/106329/using-date-in-report-definition.html
The default date format in FS Query is "yyyy-MM-dd HH:mm:ss". You can specify your own format using the DBMS function, TO_DATE e.g
SELECT {pk} FROM {Product} WHERE {modifiedtime} >= TO_DATE('2019/01/03','YYYY/MM/DD')
You can use many kinds of combinations in format e.g. if you want to use a date, something like Jan 9, 2019 11:37:46 AM, you can do it like:
SELECT {pk} FROM {Product} WHERE {modifiedtime} >= TO_DATE('Jan 9, 2019 11:37:46 AM','Mon DD, YYYY HH:MI:SS AM')
The default date format in FS Query is "yyyy-MM-dd HH:mm:ss". You can specify your own format using the DBMS function, TO_DATE e.g
SELECT {pk} FROM {Product} WHERE {modifiedtime} >= TO_DATE('2019/01/03','YYYY/MM/DD')
You can use many kinds of combinations in format e.g. if you want to use a date, something like Jan 9, 2019 11:37:46 AM, you can do it like:
SELECT {pk} FROM {Product} WHERE {modifiedtime} >= TO_DATE('Jan 9, 2019 11:37:46 AM','Mon DD, YYYY HH:MI:SS AM')
Comments
Post a Comment