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

1 vote174 views1 answer
Pgsql sum switch case
SQL
0 vote139 views1 answer
Sqlite insert or update
SQL
0 vote147 views1 answer
Arithmetic expression in sql
SQL
-1 vote127 views8 answers
Create Trigger in phpMyAdmin
SQL
0 vote134 views1 answer
Spark sql grows beyond 64 kb
SQL
0 vote140 views1 answer
Search In the Data using ObjectName
SQL
1 vote134 views2 answers
Pad zero sql server
SQL
2 votes137 views3 answers
Postgresql reset auto increment
SQL
0 vote145 views1 answer
How to check which table has data in mysql
SQL
0 vote152 views1 answer
Executescalar in sql server
SQL