If we give the sub query as SELECT SQRT(144)

naveen_kumar · New User Joined: 03 Dec 2005 Posts: 1 Location: coimbatore

if we give the sub query as SELECT SQRT(144) (or any other square numbers) <= the ans displayed is with an exponential type.

like for 144 must be 12 but ans displayed is +144.00000000+03

reachsenthilnathan · New User Joined: 20 Nov 2005 Posts: 15

Hi,

I hope u mean to say that answer is +0.1200000000000000E+02 and not 12.
(thou u have given the answer as +144.00000000+03)

Use the following query to get it as integer.
SELECT CAST (SQRT(144) AS INTEGER) FROM SYSIBM.SYSDUMMY1;

Hope it helps.

Regards,
Senthil Nathan.R