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 vote363 views1 answer
Oracle drop type
SQL
0 vote361 views3 answers
Sql query checker
SQL
0 vote362 views2 answers
Mysql create table if not exists
SQL
3 votes342 views1 answer
Oracle function
SQL
1 vote348 views1 answer
Sqlite create index
SQL
-1 vote351 views1 answer
Capitole toulouse
SQL
7 votes362 views2 answers
Mysql get year from date
SQL
1 vote329 views1 answer
Mysql find tables with column name
SQL
15 votes377 views3 answers
Postgresql change column type
SQL
4 votes368 views2 answers
Postgresql default value
SQL