Question : I want to make it possible for user to search products within a price range. User should be […]
Tag: money
PostgreSQL and MONEY data type for currency values
Question : For a project, I created a table with a column price MONEY NOT NULL column. And I thought […]
Exchange rate table and conversion on the fly in query
Question : I’m working on a small project and I’m have arrived to the point where I let a user […]
Handling currencies in a database
Question : How should money currency be handled in the database to be consistent? Should I choose the specific currency […]
How to change the datatype of a column from integer to money?
Question : I am attempting to convert a PostgreSQL table column from integer to money, but I am receiving the […]
Default value format of a stored procedure parameter(of datatype : money)
Question : With my query: SELECT (CAST(0.00 AS MONEY)) I am expecting a result : 0.00 But it shows me […]