Question : What are the downsides to storing two integers as a decimal? I am storing asset details in tables, […]
Tag: decimal
How to prevent PostgreSQL from automatically rounding numeric types?
Question : I have a simple schema and query for a MWE. Schema: CREATE TABLE ttable ( tcol Numeric(19,4) ) […]
How does SQL Server determine precision / scale?
Question : I’m running SQL Server 2012 SELECT 0.15 * 30 / 360, 0.15 / 360 * 30 Results: 0.012500, […]
MySQL bug – decimal comparison
Question : I’m currently writing unit tests for a stored procedure that calculates the amount of taxes and the tax […]
Having values or some state in a database
Question : Suppose I have a table with several price values in it ID Int, Primary Key, not null AveragePrice […]
How to count decimals without zeros
Question : How can I count all decimal place up to the first zero For example I have a column […]
Storing two integers as a decimal
Question : What are the downsides to storing two integers as a decimal? I am storing asset details in tables, […]
Average Value not working
Question : I have a database of students and grades across varying report cycles. Each Report Cycle has a unique […]
Why is datalength of decimal 5 regardless of precision?
Question : I’m trying to better understand numeric types in SQL and have read that the decimal type will always […]
Question regarding decimal arithmetic
Question : I think my understanding of precision vs scale might be incorrect as the following example produces values that […]
- 1
- 2