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

54 votes359 views6 answers
Sql rename column
SQL
0 vote162 views1 answer
Postgresql array to rows
SQL
9 votes148 views2 answers
Nosql databases
SQL
0 vote152 views1 answer
Null column as zero in mysql
SQL
4 votes208 views1 answer
Postgresql list sequences
SQL
0 vote149 views1 answer
Mysql 5.7 in centos 7
SQL
5 votes152 views2 answers
Mysql drop table cascade
SQL
0 vote145 views1 answer
Power bi find all ids not in other tables
SQL
0 vote174 views1 answer
Mysql c commands
SQL
0 vote149 views1 answer
How to return only the Date from a SQL Server DateTime datatype
SQL