Error in OQL query statement, TO_TIMESTAMP does not work
0
Hi All, After upgrading to mendix version 9 from 7 some of functions does not sup[port . one of them is TO_TIMESTAMP. Below is the error in where clause : Select * From Empoyee where JoinDate >= TO_TIMESTAMP('2024-01-01 00:00:00','YYYY-MM-DD HH24:MI:SS') com.mendix.datastorage.oqltree.AnalysisException: Unknown function name: 'TO_TIMESTAMP'' Does anyone faced this? What can I use as an alternative option? Regards
asked
Abhinay Malviya
1 answers
0
Hi Abhinary,
From the error message I assume the TO_TIMESTAMP is not supported anymore.
You could use a Data Set and hand over the DateTime value as parameter. You don't need to do any timestamp translation anymore as the platform takes care of this.