All Forums Database
Vinay151 20 posts Joined 12/14
05 Jul 2016
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

CarlosAL 512 posts Joined 04/08
06 Jul 2016

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.

Vinay151 20 posts Joined 12/14
06 Jul 2016

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

Thanks,
Vinay

You must sign in to leave a comment.