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
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.

 

answered