sahu

 Profile Answers by sahu Questions by sahu

• Jan 27th, 2006

 

Ans:

Yes,it will give the 1200

SELECT TRUNC(1234.5678,-2) FROM DUAL;

1200

Bala

• Jul 26th, 2006

 

Answer is perfectly correct.

Deep

• Oct 4th, 2006

 

 

But How it come ?

thumati_nagaraju@yahoo.co.in

• Nov 17th, 2006

 

this is -ve no given so it remove the digits before decimal point ... and replace it by zero if want to check it just try with -1 or -2 or -3 ok seeu byeee

gemini burj

 Profile Answers by gemini burj 

• Oct 23rd, 2007

 

if the -ive parameter is passed under TRUNC function truncation will be used to below decimal place i.e
-1 means Trunc to 10th (1234 becomes 1230)
-2 means trunc to 100th (1234 becomes 1200)
-3 means trunc to 1000th (1234 becomes 1000)

These parameters can also apply with the rount function
-1 means round to 10th (1647 becomes 1650)
-2 means trunc to 100th (1647 becomes 1600)
-3 means trunc to 1000th (1647 becomes 2000)
Thanks