Storing Negative Numbers in Oracle?

Hi, I hope someone could help me. I've been trying to figure out how to store this number "-118.245169" in a field called "LATITUDE". When creating the table, I created the LATITUDE field by using the "number" datatype like this: LATITUDE NUMBER(20,9), but it truncates, or actually rounds off the number to: -118.2452 . I want to use this value in a calculation, but I would like to store it without rounding it off. I'm assuming that the negative number is causing it to round off.

Any help would be appreciated...

--Sussette Received on Tue Feb 23 1999 - 12:39:37 CST