Reference library1 entry

Category: SQL and databases

Rounding and precision control in SQL queries and database systems.

SQL and databases

Significant Figures in SQL: How to Round and Store Numeric Data in Databases

SQL databases separate exact DECIMAL/NUMERIC storage from approximate FLOAT/REAL storage. Significant-figure rounding is usually a presentation or conformance step, not a storage default.

Read explanation