Posted: Fri Mar 03, 2017 5:05 am Post subject: How to call oracle TO_TIMESTAMP() in MbSQLStatement?
Novice
Joined: 05 Jul 2016 Posts: 17
Hi , I am using MbSQLStatement for ODBC connection in JCN.
When executing SELECT statement with WHERE clause , calling TO_TIMESTAMP() method to convert string into timestamp format , throws the following error:
[BIPmsgs:2558]BIP2558E: (, 1.313) : Undefined function '.TO_TIMESTAMP'.
The program is attempting to call a function which is not defined or is not in the schema path.
Correct the syntax of your ESQL expression in node '', around line and column '1.313', then redeploy the message flow. : Unknown function
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum