Decimal Value

Database
Enthusiast

Decimal Value

Hi,

   I created a column with datatype Decimal(15,2) and when I store the value 0.00 in that column, its storing as .00. So, is there any way to store my value 0.00 as it is in my Decimal column.

Thanks,

Vinay

2 REPLIES
Junior Supporter

Re: Decimal Value

Hi.

The datatype is NOT storing the value as ".00" (numbers are numbers). The FORMAT is what displays the data in one or other way.

You can define a FORMAT at column level (when creating the table, for example) or use FORMAT in your SQLs.

Cheers.

Carlos.

Enthusiast

Re: Decimal Value

Thanks Carlos.... Also, is this the default format of Decimal data type to store the value

Thanks,
Vinay