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.
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.
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