CAST(expression AS data_type)

TRY_CAST(expression AS data_type)
-- Returns NULL if conversion fails

-- SQL Server / Snowflake style
CONVERT(data_type, expression)

expression::

SELECT 
    -- String to number
    CAST('12345' AS INTEGER) as string_to_int,
    CAST('123.45' AS DECIMAL(10,2)) as string_to_decimal,
    
    -- Number to string
    CAST(12345 AS VARCHAR(10)) as int_to_string,
    CAST(123.45 AS VARCHAR(20)) as decimal_to_string,
    
    -- String to date/timestamp
    CAST('2024-01-15' AS DATE) as string_to_date,
    CAST('2024-01-15 10:30:00' AS TIMESTAMP) as string_to_timestamp,
    
    -- Number to boolean
    CAST(1 AS BOOLEAN) as one_to_true,
    CAST(0 AS BOOLEAN) as

SELECT 
    order_id,
    discount_code,
    -- CAST would fail on invalid numbers
    TRY_CAST(discount_code AS INTEGER) as discount_value,
    -- Can use with COALESCE for defaults
    COALESCE(TRY_CAST(discount_code AS INTEGER), 0) as discount_or_zero
FROM

SELECT 
    order_id,
    discount_code,
    SAFE_CAST(discount_code AS INT64) as discount_value,
    COALESCE(SAFE_CAST(discount_code AS INT64), 0) as discount_or_zero
FROM

SELECT 
    -- Using :: operator (Snowflake shorthand)
    '12345'::INTEGER as shorthand_cast,
    123.45::VARCHAR as number_to_string,
    
    -- Specific conversion functions
    TO_NUMBER('12345') as to_number,
    TO_VARCHAR(12345) as to_varchar,
    TO_DATE('2024-01-15', 'YYYY-MM-DD') as to_date,
    TO_TIMESTAMP('2024-01-15 10:30:00') as

SELECT 
    -- Must use CAST
    CAST('12345' AS INT64) as string_to_int,
    CAST(123.45 AS STRING) as number_to_string,
    
    -- Format-aware functions
    PARSE_DATE('%Y-%m-%d', '2024-01-15') as parse_date,
    PARSE_TIMESTAMP('%Y-%m-%d %H:%M:%S', '2024-01-15 10:30:00') as parse_timestamp,
    FORMAT_DATE('%B %d, %Y', DATE '2024-01-15') as

SELECT 
    -- Using :: operator
    '12345'::INT as shorthand_cast,
    123.45::STRING as number_to_string,
    
    -- Specific functions
    TO_DATE('2024-01-15', 'yyyy-MM-dd') as to_date,
    TO_TIMESTAMP('2024-01-15 10:30:00') as

SELECT 
    customer_id,
    -- Clean and convert price strings
    TRY_CAST(REPLACE(REPLACE(price_str, '$', ''), ',', '') AS DECIMAL(10,2)) as clean_price,
    
    -- Extract and convert year
    CAST(SUBSTRING(date_str, 1, 4) AS INTEGER) as year,
    
    -- Convert string boolean
    CASE 
        WHEN LOWER(TRIM(active_str)) IN ('true', 'yes', '1', 't', 'y') THEN CAST(1 AS BOOLEAN)
        WHEN LOWER(TRIM(active_str)) IN ('false', 'no', '0', 'f', 'n') THEN CAST(0 AS BOOLEAN)
        ELSE NULL
    END as is_active
FROM

SELECT 
    json_data:user_id::INTEGER as user_id,
    json_data:name::VARCHAR as name,
    json_data:age::INTEGER as age,
    TRY_CAST(json_data:salary AS DECIMAL(10,2)) as salary,
    json_data:active::BOOLEAN as is_active
FROM

SELECT 
    CAST(JSON_EXTRACT_SCALAR(json_data, '$.user_id') AS INT64) as user_id,
    JSON_EXTRACT_SCALAR(json_data, '$.name') as name,
    SAFE_CAST(JSON_EXTRACT_SCALAR(json_data, '$.age') AS INT64) as age,
    SAFE_CAST(JSON_EXTRACT_SCALAR(json_data, '$.salary') AS NUMERIC) as salary,
    CAST(JSON_EXTRACT_SCALAR(json_data, '$.active') AS BOOL) as is_active
FROM

-- Implicit casting (database does automatically)
SELECT 
    '10' + 5 as implicit_string_to_number,  -- Result: 15
    10 || ' items' as implicit_number_to_string;  -- Result: '10 items'

-- Explicit casting (recommended for clarity)
SELECT 
    CAST('10' AS INTEGER) + 5 as explicit_conversion,
    CAST(10 AS VARCHAR) || ' items' as

-- ❌ This will ERROR
SELECT CAST('abc' AS INTEGER);
-- Error: Numeric value 'abc' is not recognized

-- ✅ This returns NULL
SELECT TRY_CAST('abc' AS INTEGER) as result;
-- Result: NULL

-- Can handle with COALESCE
SELECT COALESCE(TRY_CAST('abc' AS INTEGER), -1) as result;
-- Result: -1

-- ❌ Slow: Prevents index use
WHERE CAST(id AS VARCHAR) = '12345'

-- ✅ Fast: Uses index
WHERE id = 12345