how to suppress zeroes after decimal point at the end in a value
From: hari (anonymous_at_discussions.microsoft.com)
Date: 09/23/04
- Next message: Vishal Parkar: "Re: how to suppress zeroes after decimal point at the end in a value"
- Previous message: MA: "CHECK DOUBLE RECORD"
- Next in thread: Vishal Parkar: "Re: how to suppress zeroes after decimal point at the end in a value"
- Reply: Vishal Parkar: "Re: how to suppress zeroes after decimal point at the end in a value"
- Messages sorted by: [ date ] [ thread ]
Date: Wed, 22 Sep 2004 23:31:03 -0700
hi,
i have a sql table field price and datatype is
decimal 13(20,6).
when i insert values to this field, values are being
inserted correctly. i.e. 13.45 inserted as 13.45 and
145.653 inserted as 145.653 only.
But while fetching only the values are coming as 13.450000,
145.653000, because the datatype is decimal 13(20,6) with
6 decimals. but i want 13.45, 145.653 as in the table.
How suppress the unwanted zeroes at the end of those
numbers.
any help.
thanks,
hari.
- Next message: Vishal Parkar: "Re: how to suppress zeroes after decimal point at the end in a value"
- Previous message: MA: "CHECK DOUBLE RECORD"
- Next in thread: Vishal Parkar: "Re: how to suppress zeroes after decimal point at the end in a value"
- Reply: Vishal Parkar: "Re: how to suppress zeroes after decimal point at the end in a value"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
|
