I have defined this in my astro DB
price: column.number(),
Im trying to set a value on the front end as 0.0023
But it wants a whole number. How can I fix this?
#Astro DB decimals
remote grove
fair iglooBOT
Hi @remote grove. I'm kapa.ai, your friendly support bot. I will try to answer your question by searching through the knowledge base. :wave:
Astro DB's column.number() type is used to store both integer and floating point values. Therefore, it should be able to handle decimal numbers like 0.0023 without any issues.
Here is the relevant excerpt from the Astro documentation:
- **`column.number(...)`** - store integer and floating point values
If you're encountering an issue, it might be due to some other part of your code. Make sure that the value you're trying to insert into the price column is indeed a number and not a string or any other data type.
If the problem persists, please provide more details about the error message you're receiving and the context in which this issue is occurring.