Convert a STRING constant to timestamp type using the following statement Output: Illustrate the following snapshots to understand the result of the above statement:ġ. In order to execute the above statement correctly we have to use the following syntax where instead of DOUBLE, we have to use DOUBLE PRECISION,Ĭonvert a STRING constant to Boolean type using the following statement, where the ‘FALSE’, ‘false’, ‘f’ and ‘F’ gets converted to false, and ‘TRUE’, ‘true’, ‘t’ and ‘T’ gets converted to true as follows: Output: After executing the above SQL statement, PostgreSQL will give us the following error: the value contains precision.Ģ. Now, try to convert a STRING constant to a DOUBLE type using the following statement: Output: After executing the above SQL statement, PostgreSQL will give us the following error: the value contains a character.Ĭonvert a STRING constant to DATE type using the following statement:ġ. The PostgreSQL CAST operator raises an error if the given value is not convertible to the target data type. Output: Illustrate the following snapshot to understand the result of the above statement:Ģ. Use the following statement to do the conversion: Now, Let’s have a look at the following examples, which converts one data type to another data type. Output: Illustrate the following snapshot to understand the result of the above statement. The syntax of the CAST operator’s another version is as follows as well:Ĭonsider the following example to understand the working of the PostgreSQL CAST:
The target data type is the data type to which the expression will get converted. The cast operator is used to convert one data type to another, where the table column or an expression’s data type is decided to be. How does the CAST Operator work in PostgreSQL?
target_type: Define the target data type in which we are converting the value of the exp.Hadoop, Data Science, Statistics & others
0 kommentar(er)
