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

5 votes123 views6 answers
Sql foreign key
SQL
1 vote123 views1 answer
Declare table variable
SQL
0 vote112 views1 answer
Output table plsql
SQL
2 votes116 views1 answer
Mysql Incorrect column specifier for column
SQL
0 vote112 views1 answer
Oracle query archivemode
SQL
0 vote112 views1 answer
Alter column to not null with default value sql server
SQL
-1 vote107 views2 answers
On update cascade
SQL
2 votes162 views2 answers
Mysql compare datetime to another datetime
SQL
0 vote112 views1 answer
Drop all triggers oracle
SQL
0 vote151 views1 answer
Mysql faster delete
SQL