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 vote309 views3 answers
Postgres date difference seconds
SQL
0 vote281 views1 answer
How to find sql server name
SQL
4 votes275 views2 answers
Error loading MySQLdb module.
SQL
0 vote317 views3 answers
How to assign custom id in mysql
SQL
0 vote268 views1 answer
Mysql update sequence with order by
SQL
0 vote284 views1 answer
Do postgresql
SQL
1 vote296 views2 answers
Sql server add time to date
SQL
0 vote287 views1 answer
How to connect pgadmin with excel
SQL
0 vote278 views2 answers
Create new table plsql
SQL
0 vote291 views1 answer
VSCode SQL Server Connection error
SQL