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 vote245 views1 answer
Faire une recherche par liste de mot clé sql
SQL
8 votes242 views4 answers
Postgresql server restart
SQL
0 vote252 views1 answer
Make parameters nullable in sql server
SQL
5 votes238 views4 answers
Change auto increment mysql
SQL
-1 vote230 views1 answer
Mysql #1064 error
SQL
0 vote266 views1 answer
VERIFY INDEXES WITH PARTITIONS IN SQL ORACLE
SQL
1 vote229 views1 answer
Python clean sql string
SQL
0 vote218 views1 answer
Min salary in sql
SQL
9 votes242 views3 answers
Import DB through mysql console
SQL
7 votes234 views2 answers
Postgres concat
SQL