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 vote133 views1 answer
Storing RGBA in mysql db
SQL
2 votes128 views4 answers
Check timezone of mysql database
SQL
0 vote124 views1 answer
Mysql update sum same table
SQL
1 vote113 views1 answer
Avg mysql
SQL
0 vote125 views1 answer
Get the Domain Name, Page Name and Query Parameter from a URL
SQL
0 vote173 views1 answer
Sql select without column name
SQL
0 vote156 views2 answers
Clauses in mysql
SQL
0 vote84 views1 answer
Sql truncate table referencing itself
SQL
0 vote143 views1 answer
Sql server insert inner join
SQL
0 vote117 views1 answer
Drush SQLSTATE[HY000] [2002] No such file or directory
SQL