<div>
I found the answer. The amounts are stored as epoch numbers within our PostgreSQL database. It does not look pretty, but here is what I got:<br />
update accrual_balance set balance = cast(round((balance/60)/15<wbr />.00)/4 as decimal(10,2))*60*60 &nbsp;where id = 8450<br />
<br />
Let me know if there is an easier way. <br />
<br />
Thanks
</div>


I found the answer. The amounts are stored as epoch numbers within our PostgreSQL database. It does not look pretty, but here is what I got:
update accrual_balance set balance = cast(round((balance/60)/15.00)/4 as decimal(10,2))*60*60  where id = 8450

Let me know if there is an easier way.

Thanks

<div>
<div class="content wysiwyg-content">
All,<br />
<br />
I am in the process of creating a trigger in a PostgreSQL database. I need to round the decimal number to the nearest quarter. For instance, 14.68 would be rounded to 14.75. We have a time and attendance system that round items to time and a half. The problem is that when it rounds the total time calculated for overtime it rounds it to an odd decimal such as 14.68. Our company policies dictate that these items be rounded to the nearest quarter of a decimal. The easiest way to do this is on the database end rather than editing the source code of the project. I need a PostgreSQL function that rounds the numbers past the decimal to the nearest .25. Any help would be greatly appreciated.
</div>
</div>


All,

I am in the process of creating a trigger in a PostgreSQL database. I need to round the decimal number to the nearest quarter. For instance, 14.68 would be rounded to 14.75. We have a time and attendance system that round items to time and a half. The problem is that when it rounds the total time calculated for overtime it rounds it to an odd decimal such as 14.68. Our company policies dictate that these items be rounded to the nearest quarter of a decimal. The easiest way to do this is on the database end rather than editing the source code of the project. I need a PostgreSQL function that rounds the numbers past the decimal to the nearest .25. Any help would be greatly appreciated.

PostgreSQL Rounding

PostgreSQL is an object-relational database management system with an emphasis on extensibility and standards-compliance. As a database server, its primary function is to store data securely, supporting best practices, and to allow for retrieval at the request of other software applications. PostgreSQL implements the majority of the SQL2011 standard, is ACID-compliant and transactional using multiversion concurrency control (MVCC), and handles complex SQL queries using many indexing methods that are not available in other databases. It is cross-platform and runs on many operating systems including Linux, FreeBSD, OS X, Solaris, and Microsoft Windows.