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

32 votes269 views6 answers
Insert into values select
SQL
0 vote265 views1 answer
Import big data to mysql
SQL
1 vote278 views1 answer
Change default maximum runtime mariadb from phpmyadmin
SQL
0 vote281 views1 answer
Sqlite insert or update
SQL
0 vote274 views1 answer
Sql insert query list of dictionaries
SQL
14 votes282 views1 answer
Excel
SQL
0 vote260 views1 answer
Sql remove non numeric characters
SQL
0 vote267 views1 answer
Select even number id data from table
SQL
6 votes255 views1 answer
Oracle desc table primary key
SQL
0 vote271 views1 answer
Add sqlcmd to path linux
SQL