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 vote346 views1 answer
Mysql show data from table
SQL
11 votes366 views2 answers
Mysql set safe mode off
SQL
4 votes358 views1 answer
Force drop all tables postgres
SQL
0 vote415 views3 answers
Characters found after end of sql statement
SQL
3 votes389 views2 answers
How to open postgresql in windows
SQL
1 vote386 views1 answer
Postgres set column based on another column
SQL
4 votes426 views2 answers
Delete all table oracle
SQL
1 vote454 views1 answer
Sql and
SQL
-2 votes352 views1 answer
Remove root password mysql
SQL
2 votes386 views1 answer
Oracle sql merge
SQL