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

1 vote237 views2 answers
How to drop a unique constraint in sql
SQL
2 votes318 views1 answer
Cannot return non-composite value from function that returns composite type
SQL
0 vote256 views1 answer
Mysql failed to login as root@localhost
SQL
5 votes247 views1 answer
Migrate sql table another database
SQL
1 vote265 views1 answer
Change old domain to new domain name wordpress
SQL
0 vote255 views1 answer
Get first 3 letter of department name in sql
SQL
0 vote268 views1 answer
SQL query to verify the size of the table
SQL
0 vote264 views1 answer
How to reset the database value in SQL server
SQL
0 vote241 views6 answers
Unique key in sql
SQL
11 votes271 views2 answers
You are using safe update mode
SQL