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 vote273 views1 answer
Fetcht he leftmost word in a comma separated string in sql
SQL
16 votes282 views6 answers
Install sqlite3 python
SQL
0 vote315 views1 answer
Sql datum formatieren
SQL
7 votes274 views3 answers
Can't connect to local mysql server through socket '/tmp/mysql.sock' (2)
SQL
2 votes267 views1 answer
Oracle find unusable indexes
SQL
4 votes271 views2 answers
Mysql how to change default charset
SQL
0 vote280 views1 answer
Mysql wait_timeout
SQL
2 votes265 views1 answer
Drop table purge
SQL
0 vote301 views1 answer
Mysqli::query(): (HY000/1034): Index for table 'db' is corrupt; try to repair it
SQL
0 vote290 views1 answer
Sql query to force the database to be drop
SQL