Java EE (Java Enterprise Edition) General Discussion

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

SQL-STATEMENT-ISSUE floor()

843836Sep 17 2003 — edited Sep 18 2003

SELECT (intBla + intFoo)/1024/1024 as USAGE from USER_TABLE;

e.g. (intBla + intFoo)/1024/1024 makes 152,8933. so i want 153. What should be the solution ? floor()? wouldn't be!?

SELECT floor((intBla + intFoo)/1024/1024) as USAGE from USER_TABLE;

BUT THIS DELIVERS ALSO 152 instead of 153. WHY? any suggestions? what da hell am i doing wrong?

thx

...

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 16 2003

Added on Sep 17 2003

#javaserver-pages-jsp-and-jstl

7 comments

158 views