| DOCUMENTATION | https://docs.snowflake.com |
| English | https://docs.snowflake.com/en/sql-reference/data-types-numeric |
| Français | https://docs.snowflake.com/fr/sql-reference/data-types-numeric |
| Deutsch | https://docs.snowflake.com/de/sql-reference/data-types-numeric |
| 日本語 | https://docs.snowflake.com/ja/sql-reference/data-types-numeric |
| 한국어 | https://docs.snowflake.com/ko/sql-reference/data-types-numeric |
| Português | https://docs.snowflake.com/pt/sql-reference/data-types-numeric |
| Get started | https://docs.snowflake.com/en/user-guide-getting-started |
| Guides | https://docs.snowflake.com/en/guides |
| Developer | https://docs.snowflake.com/en/developer |
| Reference | https://docs.snowflake.com/en/reference |
| Release notes | https://docs.snowflake.com/en/release-notes/overview |
| Tutorials | https://docs.snowflake.com/en/tutorials |
| Status | https://status.snowflake.com |
| Overview | https://docs.snowflake.com/en/reference |
| SQL data types reference | https://docs.snowflake.com/en/sql-reference-data-types |
| Summary | https://docs.snowflake.com/en/sql-reference/intro-summary-data-types |
| Numeric | https://docs.snowflake.com/en/sql-reference/data-types-numeric |
| String & binary | https://docs.snowflake.com/en/sql-reference/data-types-text |
| Logical | https://docs.snowflake.com/en/sql-reference/data-types-logical |
| Date & time | https://docs.snowflake.com/en/sql-reference/data-types-datetime |
| Semi-structured | https://docs.snowflake.com/en/sql-reference/data-types-semistructured |
| Structured | https://docs.snowflake.com/en/sql-reference/data-types-structured |
| Unstructured | https://docs.snowflake.com/en/sql-reference/data-types-unstructured |
| Geospatial | https://docs.snowflake.com/en/sql-reference/data-types-geospatial |
| UUID | https://docs.snowflake.com/en/sql-reference/data-types-uuid |
| Vector | https://docs.snowflake.com/en/sql-reference/data-types-vector |
| User-defined | https://docs.snowflake.com/en/sql-reference/data-types-user-defined |
| Unsupported | https://docs.snowflake.com/en/sql-reference/data-types-unsupported |
| Conversion | https://docs.snowflake.com/en/sql-reference/data-type-conversion |
| SQL command reference | https://docs.snowflake.com/en/sql-reference-commands |
| Function and stored procedure reference | https://docs.snowflake.com/en/sql-reference-functions |
| Class reference | https://docs.snowflake.com/en/sql-reference-classes |
| Scripting reference | https://docs.snowflake.com/en/sql-reference-snowflake-scripting |
| General reference | https://docs.snowflake.com/en/sql-reference |
| API reference | https://docs.snowflake.com/en/api-reference |
| Reference | https://docs.snowflake.com/en/reference |
| SQL data types reference | https://docs.snowflake.com/en/sql-reference-data-types |
| ¶ | https://docs.snowflake.com/sql-reference/data-types-numeric#numeric-data-types |
| ¶ | https://docs.snowflake.com/sql-reference/data-types-numeric#data-types-for-fixed-point-numbers |
| ¶ | https://docs.snowflake.com/sql-reference/data-types-numeric#number |
| FLOAT | https://docs.snowflake.com/sql-reference/data-types-numeric#label-data-type-float |
| ¶ | https://docs.snowflake.com/sql-reference/data-types-numeric#decimal-dec-numeric |
| ¶ | https://docs.snowflake.com/sql-reference/data-types-numeric#int-integer-bigint-smallint-tinyint-byteint |
| ¶ | https://docs.snowflake.com/sql-reference/data-types-numeric#impact-of-precision-and-scale-on-storage-size |
| ¶ | https://docs.snowflake.com/sql-reference/data-types-numeric#examples-of-fixed-point-data-types-in-a-table |
| ¶ | https://docs.snowflake.com/sql-reference/data-types-numeric#data-types-for-floating-point-numbers |
| ¶ | https://docs.snowflake.com/sql-reference/data-types-numeric#float-float4-float8 |
| ¶ | https://docs.snowflake.com/sql-reference/data-types-numeric#precision |
| Wikipedia article on double-precision numbers | https://en.wikipedia.org/wiki/Double-precision_floating-point_format |
| NUMBER | https://docs.snowflake.com/sql-reference/data-types-numeric#label-data-type-number |
| ¶ | https://docs.snowflake.com/sql-reference/data-types-numeric#special-values |
| ¶ | https://docs.snowflake.com/sql-reference/data-types-numeric#rounding-errors |
| SUM | https://docs.snowflake.com/sql-reference/functions/sum |
| AVG | https://docs.snowflake.com/sql-reference/functions/avg |
| UDFs | https://docs.snowflake.com/developer-guide/udf/udf-overview |
| stored procedures | https://docs.snowflake.com/developer-guide/stored-procedure/stored-procedures-overview |
| DECFLOAT | https://docs.snowflake.com/sql-reference/data-types-numeric#label-data-type-decfloat |
| ¶ | https://docs.snowflake.com/sql-reference/data-types-numeric#double-double-precision-real |
| ¶ | https://docs.snowflake.com/sql-reference/data-types-numeric#examples-of-floating-point-data-types-in-a-table |
| ¶ | https://docs.snowflake.com/sql-reference/data-types-numeric#decfloat |
| special values | https://docs.snowflake.com/sql-reference/data-types-numeric#label-data-type-float-special-values |
| ¶ | https://docs.snowflake.com/sql-reference/data-types-numeric#use-cases-for-the-decfloat-data-type |
| ¶ | https://docs.snowflake.com/sql-reference/data-types-numeric#usage-notes-for-the-decfloat-data-type |
| half up rounding mode | https://en.wikipedia.org/wiki/Rounding#Rounding_half_up |
| ¶ | https://docs.snowflake.com/sql-reference/data-types-numeric#drivers-and-driver-versions-that-support-the-decfloat-data-type |
| Drivers | https://docs.snowflake.com/developer-guide/drivers |
| ¶ | https://docs.snowflake.com/sql-reference/data-types-numeric#limitations-for-the-decfloat-data-type |
| semi-structured data type | https://docs.snowflake.com/sql-reference/data-types-semistructured |
| structured data type | https://docs.snowflake.com/sql-reference/data-types-structured |
| cast | https://docs.snowflake.com/sql-reference/data-type-conversion |
| Clustering keys | https://docs.snowflake.com/user-guide/tables-clustering-keys |
| Differential privacy | https://docs.snowflake.com/user-guide/diff-privacy/differential-privacy-sql-reference |
| Sensitive data classification | https://docs.snowflake.com/user-guide/classify-intro |
| Search optimization service | https://docs.snowflake.com/user-guide/search-optimization-service |
| ¶ | https://docs.snowflake.com/sql-reference/data-types-numeric#examples-for-the-decfloat-data-type |
| Show the differences between DECFLOAT and FLOAT | https://docs.snowflake.com/sql-reference/data-types-numeric#label-decfloat-example-differences-with-float |
| Use DECFLOAT values with aggregate functions | https://docs.snowflake.com/sql-reference/data-types-numeric#label-decfloat-example-aggregate-functions |
| ¶ | https://docs.snowflake.com/sql-reference/data-types-numeric#show-the-differences-between-decfloat-and-float |
| ¶ | https://docs.snowflake.com/sql-reference/data-types-numeric#use-decfloat-values-with-aggregate-functions |
| ¶ | https://docs.snowflake.com/sql-reference/data-types-numeric#numeric-constants |
| Visit Snowflake | https://www.snowflake.com |
| Join the conversation | https://community.snowflake.com/s/ |
| Develop with Snowflake | https://developers.snowflake.com |
| Share your feedback | https://docs.snowflake.com/feedback |
| Read the latest on our blog | https://www.snowflake.com/blog/ |
| Get your own certification | https://learn.snowflake.com |
| Privacy Notice | https://www.snowflake.com/privacy-policy/ |
| Site Terms | https://www.snowflake.com/legal/snowflake-site-terms/ |
| Snowflake Python APIs | https://docs.snowflake.com/developer-guide/snowflake-python-api/snowflake-python-overview |
| Snowflake REST APIs | https://docs.snowflake.com/developer-guide/snowflake-rest-api/snowflake-rest-api |
| Snowflake CLI | https://docs.snowflake.com/developer-guide/snowflake-cli/index |
| Data types for fixed-point numbers | https://docs.snowflake.com/sql-reference/data-types-numeric#data-types-for-fixed-point-numbers |
| NUMBER | https://docs.snowflake.com/sql-reference/data-types-numeric#number |
| DECIMAL , DEC , NUMERIC | https://docs.snowflake.com/sql-reference/data-types-numeric#decimal-dec-numeric |
| INT , INTEGER , BIGINT , SMALLINT , TINYINT , BYTEINT | https://docs.snowflake.com/sql-reference/data-types-numeric#int-integer-bigint-smallint-tinyint-byteint |
| Impact of precision and scale on storage size | https://docs.snowflake.com/sql-reference/data-types-numeric#impact-of-precision-and-scale-on-storage-size |
| Examples of fixed-point data types in a table | https://docs.snowflake.com/sql-reference/data-types-numeric#examples-of-fixed-point-data-types-in-a-table |
| Data types for floating-point numbers | https://docs.snowflake.com/sql-reference/data-types-numeric#data-types-for-floating-point-numbers |
| FLOAT , FLOAT4 , FLOAT8 | https://docs.snowflake.com/sql-reference/data-types-numeric#float-float4-float8 |
| DOUBLE , DOUBLE PRECISION , REAL | https://docs.snowflake.com/sql-reference/data-types-numeric#double-double-precision-real |
| Examples of floating-point data types in a table | https://docs.snowflake.com/sql-reference/data-types-numeric#examples-of-floating-point-data-types-in-a-table |
| DECFLOAT | https://docs.snowflake.com/sql-reference/data-types-numeric#decfloat |
| Numeric constants | https://docs.snowflake.com/sql-reference/data-types-numeric#numeric-constants |
| Arithmetic operators | https://docs.snowflake.com/sql-reference/operators-arithmetic |
| Comparison operators | https://docs.snowflake.com/sql-reference/operators-comparison |
| Logical operators | https://docs.snowflake.com/sql-reference/operators-logical |
| Numeric functions | https://docs.snowflake.com/sql-reference/functions-numeric |
| Conversion functions | https://docs.snowflake.com/sql-reference/functions-conversion |
| Data type conversion | https://docs.snowflake.com/sql-reference/data-type-conversion |