|
View previous topic :: View next topic
|
| Author |
Message |
sxv8193
New User
Joined: 25 Jun 2007
Posts: 5
Location: pune
|
|
|
|
Hi,
Can one tell me how to declare floating point value in DB2. eg: 23.789
Thanks
sunny |
|
| Back to top |
|
 |
jayachandra
New User
Joined: 08 Mar 2007
Posts: 3
Location: mumbai
|
|
|
|
Hi
if mean to say the column declaration
then delcare it as Column_name DECIMAL(5,3) |
|
| Back to top |
|
|
sxv8193
New User
Joined: 25 Jun 2007
Posts: 5
Location: pune
|
|
|
|
Hi,
You mentioned DECIMAL(5,3) means length of the data item is 5 and decimal point start after 2nd digit.what iam telling is correct or not ?.
if iam wrong please let me know.
Thanks
sunny |
|
| Back to top |
|
|
Phrzby Phil
Senior Member
Joined: 31 Oct 2006
Posts: 1042
Location: Richmond, Virginia
|
|
|
|
The manual (easy enough to find) is clear:
Single precision floating point: REAL
Double precision floating point: either DOUBLE or FLOAT
DECIMAL is packed-decimal with implicit decimal point. |
|
| Back to top |
|
|
|
|
