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 vote217 views1 answer
Where field is null sql knex
SQL
1 vote196 views2 answers
Sqlalchemy postgres timestamp with timezone
SQL
0 vote194 views1 answer
Sql period overlap
SQL
1 vote162 views1 answer
Database run
SQL
0 vote216 views1 answer
Sql get highest date from 3 tabels
SQL
0 vote256 views1 answer
Postgres - Login and connect as default user
SQL
8 votes199 views2 answers
Alert table name mysql
SQL
22 votes180 views2 answers
Mysql show all tables
SQL
1 vote190 views1 answer
Sql eliminare un record
SQL
4 votes194 views2 answers
Sql vs mysql
SQL