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 vote119 views1 answer
Learn sqlite dart
SQL
5 votes135 views2 answers
Oracle rename table
SQL
0 vote128 views1 answer
Select last N rows mysql
SQL
1 vote1.8K views1 answer
Dropping a constraint in ms sql
SQL
0 vote137 views1 answer
Mysql change innodb to myisam
SQL
0 vote127 views7 answers
10 random questions use python and SQL
SQL
9 votes151 views3 answers
Date format in sql
SQL
3 votes130 views1 answer
Make a field auto_increment mysql
SQL
0 vote124 views1 answer
Kill thread
SQL
0 vote131 views2 answers
Mysql dump database tables only
SQL