The term CAST came from engineering words. A simple means of this is converting from one data type to another. In Data Science, during analytics, there is an occasion where you need conversion to get data in another data type. Numeric to Char or Char to Varchar. Here, you will know the best example of CAST function usage.
CAST Function Best Data Analytics Examples
Here are Sample SQL Queries
Here, double colon refers to CAST function. It is a shortcut to the CAST function.
The Varchar (10) gets only the first 10 bytes of data from Timestamp. In reality, you have other functions to get Time from Timestamp. It is also one method you can use.
SELECT timestamp_column, CAST(timestamp_column AS varchar(10)) FROM date_time_types;
The double-colon works the same as the CAST function. You will get Time from the Timestamp.
SELECT timestamp_column::varchar(10) FROM date_time_types;
It writes numeric-column three times – original value, Integer, and Varchar of length 6.
SELECT numeric_column, CAST(numeric_column AS integer), CAST(numeric_column AS varchar(6)) FROM number_data_types;
It fails and writes an error since you cannot convert CHAR to numeric.
SELECT CAST(char_column AS integer) FROM char_data_types;
Convert DATETIME to DATE
SELECT CAST(date_time_column AS date format 'yymmdd') FROM char_data_types;
- Always check target datatype length before you use CAST
- You cannot convert CHAR to numeric value.