Convert data type in sql

Sql server convert string to date

select Cast( '2021-09-22' as date ) as castedDate;
select convert(date,'20210922') as convertedDate;

Convert data type in sql

# There are two ways to change data type. By using CAST or ::
# Eg. CAST (column_name AS target_type) OR column_name::target_type

SELECT
	CAST (date_occurred AS DATE)
    CAST (total_amount AS INTEGER)
    CAST (duration AS INTERVAL)
# OR    
    date_occurred::DATE
    total_amount::INTEGER
    duration::INTERVAL

Similar codes

0 vote153 views1 answer
Drop table BigQuery table columns
SQL
0 vote186 views1 answer
Oracle show running job
SQL
-1 vote131 views1 answer
Search all database tables for a value sqlserver
SQL
1 vote103 views1 answer
Import in mysql without a software
SQL
-1 vote142 views1 answer
Export mysql table to file
SQL
1 vote123 views1 answer
Foreign key constraint in ms sql
SQL
3 votes172 views3 answers
Cannot truncate a table referenced in a foreign key constraint
SQL
0 vote151 views1 answer
Remove transient options sql wordpress
SQL
1 vote164 views1 answer
Mysql view current queries
SQL
0 vote143 views1 answer
Reona
SQL