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

6 votes329 views2 answers
How to get yesterday date in mysql
SQL
0 vote325 views1 answer
How to print some string in mysql
SQL
-1 vote305 views1 answer
Su: Authentication failure mysql
SQL
1 vote317 views1 answer
How to delete data from sql database in android
SQL
0 vote325 views1 answer
Tsql table column constraint must be uppercase
SQL
0 vote297 views1 answer
Low level operator in dbms
SQL
0 vote320 views1 answer
Mysql query to select the highest value
SQL
0 vote323 views1 answer
View to table sql
SQL
0 vote304 views1 answer
Declarative base sqlalchemy
SQL
0 vote331 views2 answers
Mysql calcular idade
SQL