Skip to Content
-1
Jun 06, 2020 at 05:36 AM

Why CEIL and FLOOR inbuilt function is not working in OPEN SQL??

989 Views Last edit Jun 06, 2020 at 07:28 AM 2 rev

Hello Expert,

Why CIEL/Floor Function is not working . Other is working as expected but these two is creatinng the problem.

Could you please help me here.

Below is my Code -

SELECT  abs( num1 ) AS abs_value,  div(  500, 100 ) AS div_value,
        mod( 500 , 2 ) AS rem_value, round( num2, 2 ) AS round_value,
        ceil( 8.9 ) AS ceil_value
        FLOOR( 2.7 ) as floor_value 
FROM demo_expressions INTO TABLE @DATA(maths_tab).

Below is snap shot of the error -

Attachments

error.png (26.3 kB)