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 vote166 views1 answer
Uncomment listen_address=localhost
SQL
1 vote165 views1 answer
Psql client write to bash variable
SQL
1 vote163 views2 answers
Postgresql backup and restore globals and data
SQL
0 vote184 views1 answer
Sql examples from framework
SQL
4 votes175 views1 answer
Mysql set max connections
SQL
0 vote190 views1 answer
The fetch keyword oracle
SQL
0 vote164 views1 answer
Add column to table with default value plsql
SQL
62 votes191 views8 answers
Mysql add column
SQL
0 vote164 views1 answer
Check if record exists mysql
SQL
0 vote186 views1 answer
Learnxinyminutes sql
SQL