Question

How to Change the OQL query to SQL query?

0

Hi, In my application, i am using ROUND(OD_DisplayAs,2) function to round the decimal digits to 2 in OQL query. Now I want to round off the decimal digits using SQL query. When I am using the same query, It is not rounding off the decimal digits. Please help me.... Thanks, Venkat.

asked 2017-03-23

Venkatesh Lakshmaiahgari

1 answers

Pim van der Noll · Answer 1 · 2017-03-23

Try to set the loglevels to trace and pick up the generated SQL by the platform and try again..

but why do you want to use SQL?