Decimal data type?

[henry007 (Henry)]

Is there a data type in Neo4j similar to SQL's decimal type?

From my understanding, Neo only has a FLOAT type, which does not format decimals like we need it (ex, 130.10 may become 130.10000610351562).

We do use round() functions wherever possible. However, we have some use cases where we want to just have our property rounded to 2 decimals (such as NeoDash).

Thank you.

[dana_canzano]

@henry007

does apoc.number.format - APOC Documentation suffice?

[hamed.metalgear (Hamed)]

I've the same question. My application is in financial setting, and I definitely need decimal type (cannot do rounding, need data to be preserved exactly as computed).

[ameyasoft]

Try this:
RETURN round(12.3456, 2) AS roundedValue
12.35
RETURN toFloat("12.3456") as val
12.3456

https://neo4j.com/docs/cypher-manual/current/values-and-types/casting-data/