martinusso/firebird_round_number.sql

Created September 30, 2011 14:22

Star () You must be signed in to star a gist
Fork () You must be signed in to fork a gist

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/martinusso/1253876.js"></script>
Save martinusso/1253876 to your computer and use it in GitHub Desktop.

Download ZIP

Rounding numbers in Firebird

Raw

firebird_round_number.sql

cast(cast(9223373.03685 as double precision) * cast(1.0000000000 as double precision) as numeric(18, 0)) as round_number

Author

martinusso commented Sep 30, 2011

You can also avoid using the "cast" out of the calculation. Can usually use the ROUND and TRUNC functions.

round(cast(9223373.03685 as double precision) * cast(1.0000000000 as double precision)) as round_number

trunc(cast(9223373.03685 as double precision) * cast(1.0000000000 as double precision)) as truncated_number

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment