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 vote202 views1 answer
Mssql now diff 90 day
SQL
0 vote206 views1 answer
Mysqlcli how to load external sql file
SQL
1 vote214 views2 answers
Sql where is not number
SQL
1 vote204 views1 answer
Org.h2.jdbc.jdbcsqlsyntaxerrorexception
SQL
0 vote208 views1 answer
How to put is null in where in clause
SQL
0 vote195 views1 answer
Mysql date minus 1 day
SQL
2 votes210 views1 answer
Oracle convert run_duration to number
SQL
0 vote325 views1 answer
Como verificar registros duplicados no sql postgresql
SQL
11 votes170 views1 answer
Reset identity sql server
SQL
7 votes223 views6 answers
Group_concat in mysql
SQL