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 vote369 views1 answer
Sql quary intervewi question
SQL
2 votes365 views1 answer
Sql server current date minus 5 years
SQL
2 votes336 views1 answer
Select * from table where name like
SQL
0 vote335 views1 answer
Price-colour
SQL
1 vote354 views1 answer
Sql first
SQL
0 vote323 views1 answer
Show all mongodb
SQL
0 vote362 views1 answer
Sort by
SQL
0 vote330 views1 answer
Char varchar nvarchar sql
SQL
0 vote344 views2 answers
How to know the character set of an oracle databes
SQL
1 vote372 views2 answers
Procedure syntax
SQL