# Inserting decimal number in aerospike

**URL:** <https://discuss.aerospike.com/t/inserting-decimal-number-in-aerospike/4825>\
**Category:** General Discussion\
**Created:** [December 18, 2017, 12:58pm UTC](https://discuss.aerospike.com/t/inserting-decimal-number-in-aerospike/4825 "2017-12-18T12:58:41Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Vishal\_Paike](https://avatars.discourse-cdn.com/v4/letter/v/da6949/32.png) [@Vishal\_Paike](https://discuss.aerospike.com/u/Vishal_Paike)\
**Post date:** [December 18, 2017, 12:58pm UTC](https://discuss.aerospike.com/t/inserting-decimal-number-in-aerospike/4825/1 "2017-12-18T12:58:41Z")

</div>

Aerospike Community Edition build 3.14.1.3

When I am inserting the decimal number 76.3269 in aerospike using aql, the value actually being inserted in aerospike is 76.32689999999999.

Please help here.

Regards, Vishal

---

<div class="post-metadata">

**Author:** ![kporter](https://sea1.discourse-cdn.com/flex019/user_avatar/discuss.aerospike.com/kporter/32/515_2.png) [@kporter](https://discuss.aerospike.com/u/kporter)\
**Post date:** [December 18, 2017, 4:30pm UTC](https://discuss.aerospike.com/t/inserting-decimal-number-in-aerospike/4825/2 "2017-12-18T16:30:49Z")

</div>

Aerospike stores floating point values as double precision IEEE 754 floating points. I believe this is an example of a normal floating point rounding error.

> **[The Floating-Point Guide - Comparison](https://floating-point-gui.de/errors/comparison/)**
>
> Explanation of the various pitfalls in comparing floating-point numbers.

---

<div class="post-metadata">

**Author:** ![system](https://sea1.discourse-cdn.com/flex019/user_avatar/discuss.aerospike.com/system/32/2274_2.png) [@system](https://discuss.aerospike.com/u/system)\
**Post date:** [August 30, 2019, 12:56am UTC](https://discuss.aerospike.com/t/inserting-decimal-number-in-aerospike/4825/3 "2019-08-30T00:56:37Z")

</div>

This topic was automatically closed 6 days after the last reply. New replies are no longer allowed.
