Type Conversion Functions

This section describes type conversion functions, including their syntax, parameters, and usage examples.

**Table 1** Type conversion functions
Function	Description
cast	Converts a value from one data type to another and provides the data type to dynamic parameters.

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)

**Table 2** Parameter description
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

Return value type: target data type

Example: select cast(time as date)

**Table 4** Query and analysis results
Type	Query Statement	Returned Result
Scenario	cast(time as date)	2023-08-31 23:11:17.000

Parent topic: SQL Functions

Thank you very much for your feedback. We will continue working to improve the documentation.

The system is busy. Please try again later.

Which of the following issues have you encountered?

Content is inconsistent with the product UI

Unclear descriptions

Lack of examples or code

Incorrect steps

Can't find what I need

Lack of best practices

Feedback (optional)

0/500

Select at least one type of issue, and enter your comments or suggestions.

Enter a maximum of 500 characters.

Submit Cancel