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

17 votes200 views1 answer
Selecting name that contain certain word in sql
SQL
1 vote170 views1 answer
How to open closed port mysql in ubuntu
SQL
1 vote168 views1 answer
Truncate left characters mysql
SQL
1 vote148 views1 answer
Sql server 2016 reseed identity
SQL
0 vote171 views1 answer
Linebreak sql
SQL
0 vote174 views1 answer
Where in clause tsql
SQL
57 votes2.2K views5 answers
How to create a new user in postgresql
SQL
2 votes189 views2 answers
Create temporary table in mysql
SQL
1 vote171 views1 answer
Postgresql delete cascade
SQL
2 votes211 views1 answer
Datefromparts mssql
SQL