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 vote153 views1 answer
Shell script to log mysql cpu usage
SQL
10 votes157 views2 answers
What is database
SQL
0 vote101 views1 answer
Now() -1 mysql
SQL
1 vote138 views1 answer
Psql show with user is logged in
SQL
-1 vote151 views1 answer
Spring boot mysql connection properties
SQL
1 vote211 views1 answer
Oracle see column type
SQL
0 vote187 views1 answer
Capabilities of sql select statements
SQL
0 vote157 views1 answer
Mysql delete from where like
SQL
1 vote138 views3 answers
How to truncate foreign key constraint table
SQL
0 vote168 views1 answer
Convert LDAP Epoch to Date
SQL