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 vote368 views1 answer
Create table split string function in sql server
SQL
1 vote335 views1 answer
Oracle create as select
SQL
0 vote404 views1 answer
Sqlite schema structure of a relational database
SQL
0 vote371 views1 answer
Postgresql print sessions using the database
SQL
0 vote355 views1 answer
Mysql multiple group by
SQL
0 vote326 views1 answer
Knex last insert id mysql
SQL
0 vote317 views1 answer
Delete double on SQL with multiple primary keys
SQL
3 votes309 views1 answer
What is having clause
SQL
19 votes338 views5 answers
Mysql between date range
SQL
0 vote421 views1 answer
Sqlite display headers on columns
SQL