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

10 votes352 views4 answers
SELECT FROM WHERE
SQL
0 vote334 views1 answer
Mysql url data type
SQL
0 vote316 views1 answer
Safe mysql
SQL
2 votes355 views1 answer
Postgresql create table as select
SQL
1 vote341 views1 answer
ORA-01950
SQL
4 votes335 views6 answers
Sql select statement
SQL
3 votes333 views1 answer
Set default today mysql
SQL
1 vote314 views1 answer
Create table variable in sql stored procedure
SQL
0 vote381 views1 answer
Osm2pgsql mac
SQL
0 vote325 views2 answers
Starting mysql service from mac
SQL