Difference between Numeric and Decimal in SQL

chensq1970 注册会员
2023-01-25 08:41

NUMERIC(p, s) takes two arguments: precision (p) and scale (s). Numeric datatype enforces the exact precision and scale that you have specified.

On other side, DECIMAL(p, s) also takes the same two arguments. However, with the DECIMAL data type, the precision can be greater than the value you have supplied. Thus, this data type can provide you with more flexibility.

About the Author

Question Info

Publish Time
2023-01-25 08:41
Update Time
2023-01-25 08:41