What's the difference between numeric[(p[,s])] and decimal[(p[,s])] as SQL datatype?
Asked
Active
Viewed 375 times
0
-
Try this - https://stackoverflow.com/questions/1841915/difference-between-decimal-and-numeric – Rohit Dhiman Jun 28 '22 at 04:15
1 Answers
0
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.
ak17
- 132
- 2
- 8