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 vote186 views1 answer
Grant privileges mysql to database 1064
SQL
0 vote291 views1 answer
Mysql delete entire row on condition
SQL
0 vote147 views1 answer
SQL column name Oracle
SQL
2 votes207 views5 answers
Install postgresql 10 centos 7
SQL
8 votes170 views1 answer
Oracle search text in all packages
SQL
0 vote148 views3 answers
Sql server obtener fecha en formato dd/mm/yyyy
SQL
1 vote122 views1 answer
Unique vs distinct sql
SQL
0 vote161 views1 answer
How to avoid duplicate records in sqlite
SQL
0 vote185 views2 answers
Postgres isnull
SQL
0 vote162 views1 answer
Create table split string function in sql server
SQL