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 vote264 views1 answer
Sql injection
SQL
0 vote259 views1 answer
Create domain sql
SQL
2 votes286 views1 answer
Postgresql create schema in specific database
SQL
0 vote287 views1 answer
Find usage of table in sql server
SQL
2 votes285 views1 answer
Mysql now format
SQL
21 votes273 views3 answers
Sql average
SQL
3 votes281 views1 answer
Kill mysql processlist in whose time more than 200
SQL
9 votes285 views4 answers
Oracle get table column names
SQL
0 vote254 views1 answer
How to install Firebird
SQL
1 vote267 views1 answer
Search for tables with name postgresql
SQL