According to the SQL92 spec, can I store the value 1 in a field where the precision = scale?

4 votes

1 answer

181 views

                          Is it SQL92 compliant to store the number 1 in a field that is defined as NUMERIC 3,3?

What about DECIMAL 3,3?  

Does this mean that the precision is a floating decimal place or static that must have 3 decimal places even if they are all zero?

Asked by jcalfee314 (185 rep)

Aug 5, 2012, 02:05 PM
Last activity: Oct 29, 2018, 03:22 PM

According to the SQL92 spec, can I store the value 1 in a field where the precision = scale?

Related Questions