Upsolver
Search…
Welcome to Upsolver
Getting Started
Start using Upsolver for free
Get started as a Upsolver user
Upsolver concepts
Upsolver Amazon AWS deployment guide
Tutorials and FAQ
Glossary
Language guide
SQL syntax reference
Functions
Aggregation Functions
Calculated functions
Aerospike functions
Array functions
Conditional functions
Date functions
External API functions
Filter functions
Numeric functions
Spacial functions
String functions
Structural functions
Type conversion functions
Data formats
Data types and features
Database output options
Permissions list
Index
Troubleshooting
Connecting data sources
Amazon AWS data sources
Microsoft Azure data sources
Kafka data source
Google Cloud Storage data source
File upload data source
CDC data sources (Debezium)
JDBC data source
HDFS data source
Data source UI
Data source properties
Data outputs and data transformation
Data outputs
Data transformation
Guide for developers
Upsolver REST API
CI/CD on Upsolver
Administration
Connections
Clusters
Python UDF
Reference data
Workspaces
Monitoring
Security
Release notes
Change log
Support
Upsolver support portal
Powered By GitBook
Type conversion functions
This page goes over the type conversion functions in Upsolver.

HEX_TO_DECIMAL

Converts a hexadecimal string value to its corresponding decimal number.
input
result
"###"
null
"ff"
255
"0xff"
255

TO_DOUBLE

Convert a number to a double.
value
result
3
3.0
3.5
3.5

TO_FLOAT

Convert a number to a float.
value
result
3
3.0
3.5
3.5
-3.5
-3.5

TO_INT

Convert a number to an integer.
value
result
3
3
3.5
3
-3.5
-3

TO_LONG

Convert a number to a long.
value
result
3
3
3.5
3
-3.5
-3

TO_NUMBER

Convert to a number type.
value
result
"###"
null
"10"
10
"5.1"
5.1
5.1
5.1

TO_STRING

Converts any value to a string.
input
result
1
"1"
1.5
"1.5"
Previous
ZIP
Next
Data formats
Last modified 1yr ago
Copy link
Contents
HEX_TO_DECIMAL
TO_DOUBLE
TO_FLOAT
TO_INT
TO_LONG
TO_NUMBER
TO_STRING