Decimal data type
400 views
Skip to first unread message
Vitalijus Vidinevicius
Jun 17, 2016, 10:26:51 AM6/17/16
to ClickHouse
Hello,
does ClickHouse support a decimal(x,y) datatype? If not, are there any plans to add it?
does ClickHouse support a decimal(x,y) datatype? If not, are there any plans to add it?
man...@gmail.com
Jun 17, 2016, 5:38:57 PM6/17/16
to ClickHouse
ClickHouse currently doesn't support decimal data type.
It is recommended to store money in (for example) millionths parts of currency unit in Int64 type.
It is like NUMERIC/DECIMAL types, but you need to divide or multiply by 1000000.
Reply all
Reply to author
Forward
0 new messages