René's URL Explorer Experiment


Title: Data type conversion | Snowflake Documentation

direct link

Domain: docs.snowflake.com

Links:

DOCUMENTATIONhttps://docs.snowflake.com
Englishhttps://docs.snowflake.com/en/sql-reference/data-type-conversion
Françaishttps://docs.snowflake.com/fr/sql-reference/data-type-conversion
Deutschhttps://docs.snowflake.com/de/sql-reference/data-type-conversion
日本語https://docs.snowflake.com/ja/sql-reference/data-type-conversion
한국어https://docs.snowflake.com/ko/sql-reference/data-type-conversion
Portuguêshttps://docs.snowflake.com/pt/sql-reference/data-type-conversion
Get startedhttps://docs.snowflake.com/en/user-guide-getting-started
Guideshttps://docs.snowflake.com/en/guides
Developerhttps://docs.snowflake.com/en/developer
Referencehttps://docs.snowflake.com/en/reference
Release noteshttps://docs.snowflake.com/en/release-notes/overview
Tutorialshttps://docs.snowflake.com/en/tutorials
Statushttps://status.snowflake.com
Overviewhttps://docs.snowflake.com/en/reference
SQL data types referencehttps://docs.snowflake.com/en/sql-reference-data-types
Summaryhttps://docs.snowflake.com/en/sql-reference/intro-summary-data-types
Numerichttps://docs.snowflake.com/en/sql-reference/data-types-numeric
String & binaryhttps://docs.snowflake.com/en/sql-reference/data-types-text
Logicalhttps://docs.snowflake.com/en/sql-reference/data-types-logical
Date & timehttps://docs.snowflake.com/en/sql-reference/data-types-datetime
Semi-structuredhttps://docs.snowflake.com/en/sql-reference/data-types-semistructured
Structuredhttps://docs.snowflake.com/en/sql-reference/data-types-structured
Unstructuredhttps://docs.snowflake.com/en/sql-reference/data-types-unstructured
Geospatialhttps://docs.snowflake.com/en/sql-reference/data-types-geospatial
UUIDhttps://docs.snowflake.com/en/sql-reference/data-types-uuid
Vectorhttps://docs.snowflake.com/en/sql-reference/data-types-vector
User-definedhttps://docs.snowflake.com/en/sql-reference/data-types-user-defined
Unsupportedhttps://docs.snowflake.com/en/sql-reference/data-types-unsupported
Conversionhttps://docs.snowflake.com/en/sql-reference/data-type-conversion
SQL command referencehttps://docs.snowflake.com/en/sql-reference-commands
Function and stored procedure referencehttps://docs.snowflake.com/en/sql-reference-functions
Class referencehttps://docs.snowflake.com/en/sql-reference-classes
Scripting referencehttps://docs.snowflake.com/en/sql-reference-snowflake-scripting
General referencehttps://docs.snowflake.com/en/sql-reference
API referencehttps://docs.snowflake.com/en/api-reference
Referencehttps://docs.snowflake.com/en/reference
SQL data types referencehttps://docs.snowflake.com/en/sql-reference-data-types
https://docs.snowflake.com/sql-reference/data-type-conversion#data-type-conversion
INTEGERhttps://docs.snowflake.com/sql-reference/data-types-numeric#label-data-type-integer
floating-point data typehttps://docs.snowflake.com/sql-reference/data-types-numeric#label-data-types-for-floating-point-numbers
https://docs.snowflake.com/sql-reference/data-type-conversion#explicit-casting-vs-implicit-casting
https://docs.snowflake.com/sql-reference/data-type-conversion#explicit-casting
CASThttps://docs.snowflake.com/sql-reference/functions/cast
TO_DOUBLEhttps://docs.snowflake.com/sql-reference/functions/to_double
https://docs.snowflake.com/sql-reference/data-type-conversion#implicit-casting-coercion
https://docs.snowflake.com/sql-reference/data-type-conversion#casting-and-precedence
https://docs.snowflake.com/sql-reference/data-type-conversion#data-types-that-can-be-cast
CASThttps://docs.snowflake.com/sql-reference/functions/cast
TO_BOOLEANhttps://docs.snowflake.com/sql-reference/functions/to_boolean
semi-structured typeshttps://docs.snowflake.com/sql-reference/data-types-semistructured
structured typeshttps://docs.snowflake.com/sql-reference/data-types-structured
Converting structured and semi-structured typeshttps://docs.snowflake.com/sql-reference/data-types-structured#label-structured-types-casting
VARCHARhttps://docs.snowflake.com/sql-reference/data-types-text#label-character-datatypes
TO_VARCHARhttps://docs.snowflake.com/sql-reference/functions/to_char
VARIANThttps://docs.snowflake.com/sql-reference/data-types-semistructured#label-data-type-variant
TO_VARIANThttps://docs.snowflake.com/sql-reference/functions/to_variant
VECTORhttps://docs.snowflake.com/sql-reference/data-types-vector#label-data-type-vector
explicit castinghttps://docs.snowflake.com/sql-reference/data-type-conversion#label-data-type-explicit-casting
Vector conversionhttps://docs.snowflake.com/sql-reference/data-types-vector#label-data-type-vector-conversion
VARCHARhttps://docs.snowflake.com/sql-reference/data-types-text#label-character-datatypes
TO_VARCHARhttps://docs.snowflake.com/sql-reference/functions/to_char
VARIANThttps://docs.snowflake.com/sql-reference/data-types-semistructured#label-data-type-variant
TO_VARIANThttps://docs.snowflake.com/sql-reference/functions/to_variant
DECFLOAThttps://docs.snowflake.com/sql-reference/data-types-numeric#label-data-type-decfloat
TO_DECFLOAThttps://docs.snowflake.com/sql-reference/functions/to_decfloat
NUMBERhttps://docs.snowflake.com/sql-reference/data-types-numeric#label-data-type-number
TO_NUMBERhttps://docs.snowflake.com/sql-reference/functions/to_decimal
VARCHARhttps://docs.snowflake.com/sql-reference/data-types-text#label-character-datatypes
TO_VARCHARhttps://docs.snowflake.com/sql-reference/functions/to_char
VARIANThttps://docs.snowflake.com/sql-reference/data-types-semistructured#label-data-type-variant
TO_VARIANThttps://docs.snowflake.com/sql-reference/functions/to_variant
TIMESTAMPhttps://docs.snowflake.com/sql-reference/data-types-datetime#label-datatypes-timestamp
TO_TIMESTAMPhttps://docs.snowflake.com/sql-reference/functions/to_timestamp
VARCHARhttps://docs.snowflake.com/sql-reference/data-types-text#label-character-datatypes
TO_VARCHARhttps://docs.snowflake.com/sql-reference/functions/to_char
VARIANThttps://docs.snowflake.com/sql-reference/data-types-semistructured#label-data-type-variant
TO_VARIANThttps://docs.snowflake.com/sql-reference/functions/to_variant
BOOLEANhttps://docs.snowflake.com/sql-reference/data-types-logical
TO_BOOLEANhttps://docs.snowflake.com/sql-reference/functions/to_boolean
FLOAThttps://docs.snowflake.com/sql-reference/data-types-numeric#label-data-types-for-floating-point-numbers
TO_DOUBLEhttps://docs.snowflake.com/sql-reference/functions/to_double
NUMBER[(p,s)]https://docs.snowflake.com/sql-reference/data-types-numeric#label-data-type-number
TO_NUMBERhttps://docs.snowflake.com/sql-reference/functions/to_decimal
VARCHARhttps://docs.snowflake.com/sql-reference/data-types-text#label-character-datatypes
TO_VARCHARhttps://docs.snowflake.com/sql-reference/functions/to_char
BOOLEANhttps://docs.snowflake.com/sql-reference/data-types-logical
TO_BOOLEANhttps://docs.snowflake.com/sql-reference/functions/to_boolean
DECFLOAThttps://docs.snowflake.com/sql-reference/data-types-numeric#label-data-type-decfloat
TO_DECFLOAThttps://docs.snowflake.com/sql-reference/functions/to_decfloat
NUMBER[(p,s)]https://docs.snowflake.com/sql-reference/data-types-numeric#label-data-type-number
TO_NUMBERhttps://docs.snowflake.com/sql-reference/functions/to_decimal
VARCHARhttps://docs.snowflake.com/sql-reference/data-types-text#label-character-datatypes
TO_VARCHARhttps://docs.snowflake.com/sql-reference/functions/to_char
VARIANThttps://docs.snowflake.com/sql-reference/data-types-semistructured#label-data-type-variant
TO_VARIANThttps://docs.snowflake.com/sql-reference/functions/to_variant
VARIANThttps://docs.snowflake.com/sql-reference/data-types-semistructured#label-data-type-variant
TO_VARIANThttps://docs.snowflake.com/sql-reference/functions/to_variant
VARIANThttps://docs.snowflake.com/sql-reference/data-types-semistructured#label-data-type-variant
TO_VARIANThttps://docs.snowflake.com/sql-reference/functions/to_variant
NUMBER[(p,s)]https://docs.snowflake.com/sql-reference/data-types-numeric#label-data-type-number
TO_NUMBERhttps://docs.snowflake.com/sql-reference/functions/to_decimal
VARCHARhttps://docs.snowflake.com/sql-reference/data-types-text#label-character-datatypes
TO_VARCHARhttps://docs.snowflake.com/sql-reference/functions/to_char
BOOLEANhttps://docs.snowflake.com/sql-reference/data-types-logical
TO_BOOLEANhttps://docs.snowflake.com/sql-reference/functions/to_boolean
DECFLOAThttps://docs.snowflake.com/sql-reference/data-types-numeric#label-data-type-decfloat
TO_DECFLOAThttps://docs.snowflake.com/sql-reference/functions/to_decfloat
FLOAThttps://docs.snowflake.com/sql-reference/data-types-numeric#label-data-types-for-floating-point-numbers
TO_DOUBLEhttps://docs.snowflake.com/sql-reference/functions/to_double
Interval data typeshttps://docs.snowflake.com/sql-reference/data-types-datetime#label-datatypes-interval-variations
TIMESTAMPhttps://docs.snowflake.com/sql-reference/data-types-datetime#label-datatypes-timestamp
TO_TIMESTAMPhttps://docs.snowflake.com/sql-reference/functions/to_timestamp
[1]https://docs.snowflake.com/sql-reference/data-type-conversion#footnote-1
VARCHARhttps://docs.snowflake.com/sql-reference/data-types-text#label-character-datatypes
TO_VARCHARhttps://docs.snowflake.com/sql-reference/functions/to_char
VARIANThttps://docs.snowflake.com/sql-reference/data-types-semistructured#label-data-type-variant
TO_VARIANThttps://docs.snowflake.com/sql-reference/functions/to_variant
ARRAYhttps://docs.snowflake.com/sql-reference/data-types-semistructured#label-data-type-array
TO_ARRAYhttps://docs.snowflake.com/sql-reference/functions/to_array
VARCHARhttps://docs.snowflake.com/sql-reference/data-types-text#label-character-datatypes
TO_VARCHARhttps://docs.snowflake.com/sql-reference/functions/to_char
VARIANThttps://docs.snowflake.com/sql-reference/data-types-semistructured#label-data-type-variant
TO_VARIANThttps://docs.snowflake.com/sql-reference/functions/to_variant
VARCHARhttps://docs.snowflake.com/sql-reference/data-types-text#label-character-datatypes
TO_VARCHARhttps://docs.snowflake.com/sql-reference/functions/to_char
VARIANThttps://docs.snowflake.com/sql-reference/data-types-semistructured#label-data-type-variant
TO_VARIANThttps://docs.snowflake.com/sql-reference/functions/to_variant
DATEhttps://docs.snowflake.com/sql-reference/data-types-datetime#label-datatypes-date
TO_DATE , DATEhttps://docs.snowflake.com/sql-reference/functions/to_date
TIMEhttps://docs.snowflake.com/sql-reference/data-types-datetime#label-datatypes-time
TO_TIME , TIMEhttps://docs.snowflake.com/sql-reference/functions/to_time
VARCHARhttps://docs.snowflake.com/sql-reference/data-types-text#label-character-datatypes
TO_VARCHARhttps://docs.snowflake.com/sql-reference/functions/to_char
VARIANThttps://docs.snowflake.com/sql-reference/data-types-semistructured#label-data-type-variant
TO_VARIANThttps://docs.snowflake.com/sql-reference/functions/to_variant
BOOLEANhttps://docs.snowflake.com/sql-reference/data-types-logical
TO_BOOLEANhttps://docs.snowflake.com/sql-reference/functions/to_boolean
DATEhttps://docs.snowflake.com/sql-reference/data-types-datetime#label-datatypes-date
TO_DATE , DATEhttps://docs.snowflake.com/sql-reference/functions/to_date
DECFLOAThttps://docs.snowflake.com/sql-reference/data-types-numeric#label-data-type-decfloat
TO_DECFLOAThttps://docs.snowflake.com/sql-reference/functions/to_decfloat
FLOAThttps://docs.snowflake.com/sql-reference/data-types-numeric#label-data-types-for-floating-point-numbers
TO_DOUBLEhttps://docs.snowflake.com/sql-reference/functions/to_double
Interval data typeshttps://docs.snowflake.com/sql-reference/data-types-datetime#label-datatypes-interval-variations
interval literalhttps://docs.snowflake.com/sql-reference/data-types-datetime#label-interval-data-types-interval-literals
NUMBER[(p,s)]https://docs.snowflake.com/sql-reference/data-types-numeric#label-data-types-for-fixed-point-numbers
TO_NUMBERhttps://docs.snowflake.com/sql-reference/functions/to_decimal
TIMEhttps://docs.snowflake.com/sql-reference/data-types-datetime#label-datatypes-time
TO_TIME , TIMEhttps://docs.snowflake.com/sql-reference/functions/to_time
TIMESTAMPhttps://docs.snowflake.com/sql-reference/data-types-datetime#label-datatypes-timestamp
TO_TIMESTAMPhttps://docs.snowflake.com/sql-reference/functions/to_timestamp
UUIDhttps://docs.snowflake.com/sql-reference/data-types-uuid
TO_UUIDhttps://docs.snowflake.com/sql-reference/functions/to_uuid
VARIANThttps://docs.snowflake.com/sql-reference/data-types-semistructured#label-data-type-variant
TO_VARIANThttps://docs.snowflake.com/sql-reference/functions/to_variant
VARCHARhttps://docs.snowflake.com/sql-reference/data-types-text#label-character-datatypes
TO_VARCHARhttps://docs.snowflake.com/sql-reference/functions/to_char
ARRAYhttps://docs.snowflake.com/sql-reference/data-types-semistructured#label-data-type-array
TO_ARRAYhttps://docs.snowflake.com/sql-reference/functions/to_array
BOOLEANhttps://docs.snowflake.com/sql-reference/data-types-logical
TO_BOOLEANhttps://docs.snowflake.com/sql-reference/functions/to_boolean
DATEhttps://docs.snowflake.com/sql-reference/data-types-datetime#label-datatypes-date
TO_DATE , DATEhttps://docs.snowflake.com/sql-reference/functions/to_date
FLOAThttps://docs.snowflake.com/sql-reference/data-types-numeric#label-data-types-for-floating-point-numbers
TO_DOUBLEhttps://docs.snowflake.com/sql-reference/functions/to_double
GEOGRAPHYhttps://docs.snowflake.com/sql-reference/data-types-geospatial
TO_GEOGRAPHYhttps://docs.snowflake.com/sql-reference/functions/to_geography
NUMBER[(p,s)]https://docs.snowflake.com/sql-reference/data-types-numeric#label-data-types-for-fixed-point-numbers
TO_NUMBERhttps://docs.snowflake.com/sql-reference/functions/to_decimal
OBJECThttps://docs.snowflake.com/sql-reference/data-types-semistructured#label-data-type-object
TO_OBJECThttps://docs.snowflake.com/sql-reference/functions/to_object
TIMEhttps://docs.snowflake.com/sql-reference/data-types-datetime#label-datatypes-time
TO_TIME , TIMEhttps://docs.snowflake.com/sql-reference/functions/to_time
TIMESTAMPhttps://docs.snowflake.com/sql-reference/data-types-datetime#label-datatypes-timestamp
TO_TIMESTAMPhttps://docs.snowflake.com/sql-reference/functions/to_timestamp
VARCHARhttps://docs.snowflake.com/sql-reference/data-types-text#label-character-datatypes
TO_VARCHARhttps://docs.snowflake.com/sql-reference/functions/to_char
VECTORhttps://docs.snowflake.com/sql-reference/data-types-vector#label-data-type-vector
ARRAYhttps://docs.snowflake.com/sql-reference/data-types-semistructured#label-data-type-array
TO_ARRAYhttps://docs.snowflake.com/sql-reference/functions/to_array
https://docs.snowflake.com/sql-reference/data-type-conversion#usage-notes
implicit conversionhttps://docs.snowflake.com/sql-reference/data-type-conversion#label-when-coercion-occurs
casthttps://docs.snowflake.com/sql-reference/data-type-conversion#label-data-type-explicit-casting
IFNULLhttps://docs.snowflake.com/sql-reference/functions/ifnull
Scale and precision in arithmetic operationshttps://docs.snowflake.com/sql-reference/operators-arithmetic#label-scale-and-precision-in-arithmetic-operations
Visit Snowflakehttps://www.snowflake.com
Join the conversationhttps://community.snowflake.com/s/
Develop with Snowflakehttps://developers.snowflake.com
Share your feedbackhttps://docs.snowflake.com/feedback
Read the latest on our bloghttps://www.snowflake.com/blog/
Get your own certificationhttps://learn.snowflake.com
Privacy Noticehttps://www.snowflake.com/privacy-policy/
Site Termshttps://www.snowflake.com/legal/snowflake-site-terms/
Snowflake Python APIshttps://docs.snowflake.com/developer-guide/snowflake-python-api/snowflake-python-overview
Snowflake REST APIshttps://docs.snowflake.com/developer-guide/snowflake-rest-api/snowflake-rest-api
Snowflake CLIhttps://docs.snowflake.com/developer-guide/snowflake-cli/index
Explicit casting vs implicit castinghttps://docs.snowflake.com/sql-reference/data-type-conversion#explicit-casting-vs-implicit-casting
Casting and precedencehttps://docs.snowflake.com/sql-reference/data-type-conversion#casting-and-precedence
Data types that can be casthttps://docs.snowflake.com/sql-reference/data-type-conversion#data-types-that-can-be-cast
Usage noteshttps://docs.snowflake.com/sql-reference/data-type-conversion#usage-notes
SQL data types referencehttps://docs.snowflake.com/sql-reference-data-types
Conversion functionshttps://docs.snowflake.com/sql-reference/functions-conversion

Viewport: width=device-width

URLs of crawlers that visited me.