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 vote336 views1 answer
How to read the potentail error messages in ssis package
SQL
6 votes340 views2 answers
Mysql interval 1 day
SQL
14 votes358 views3 answers
How to add default constraint in mysql
SQL
0 vote337 views1 answer
Sql query to return field name of a table
SQL
0 vote319 views1 answer
Install mysql 8 linux
SQL
0 vote379 views1 answer
Psql create usr
SQL
0 vote325 views1 answer
RowDataPacket
SQL
0 vote372 views1 answer
Postgresql custom order by
SQL
1 vote322 views1 answer
List index mysql cli
SQL
11 votes339 views3 answers
Change column name sql server management studio
SQL