![]() By using this site, you hereby acknowledge that any reliance upon any materials shall be at your sole risk. This site may not be used for any illegal or illicit purpose and Tudip Technologies reserves the right, at its sole discretion and without notice of any kind, to remove anything posted to this site. The inclusion of any part of this blog in another work, whether in printed or electronic or other form, or inclusion of any part of the blog in another website by linking, framing or otherwise without the express permission of Tudip Technologies is prohibited. Tudip Technologies makes no guarantees or promises regarding these websites and does not necessarily endorse or approve of their content. This site may contain links to other websites. All information is provided on an as-is basis without any obligation to make improvements or to correct errors or omissions. Tudip Technologies will not be liable for any errors, omissions, or delays in this information or any losses, injuries, or damages arising from its display or use of the information on this site. Tudip Technologies provides no endorsement and makes no representations as to accuracy, reliability, completeness, suitability or validity of any information or content on, distributed through or linked, downloaded or accessed from this site. You can also test by 411.77 5671.99 to know how its workĪll content provided on this blog is for informational purposes only. Description: Sql server function to round up/down to nearest dollar, nearest 5/10 dollar,Įlse can test it by following sql scripts PostgreSQL ROUND() function Last update on Aug21:51:31 (UTC/GMT +8 hours) ROUND() function The PostgreSQL round() function is used to return the value after rounded a number upto a specific decimal places, provided in the argument. Here is a small function that you can add in your database to achieve this result. This can be done at either the coding end or at the Database end itself. For example, you might need to display 1.44 as 1.45 and 1.89 as 1.90. In an application you need to round up numbers to nearest 5 or nearest 10 all the time.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |