Type Conversion Functions
This section describes type conversion functions, including their syntax, parameters, and usage examples.
Function List
Function |
Description |
---|---|
Converts a value from one data type to another and provides the data type to dynamic parameters. |
cast
This function converts a value from one data type to another and provides the data type to dynamic parameters.
The cast expressions can be used wherever expressions are allowed.
Syntax: CAST(Expression as Datatype)
Parameter |
Description |
Type |
Mandatory |
---|---|---|---|
expression |
Source type of the expression. |
Any |
Yes |
Datatype |
Target type. |
SQL data type, such as bigint, varchar, double, double precision, boolean, timestamp, decimal, integer, char, or date |
Yes |
Index Data Type |
SQL Data Type |
---|---|
Long |
Bigint |
String |
Varchar |
Float |
Double or double precision |
Return value type: target data type
Example: select cast(time as date)
Type |
Query Statement |
Returned Result |
---|---|---|
Scenario |
cast(time as date) |
2023-08-31 23:11:17.000 |
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.See the reply and handling status in My Cloud VOC.
For any further questions, feel free to contact us through the chatbot.
Chatbot