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 vote196 views1 answer
Query to count the number of rows in a table in sqlalchemy
SQL
0 vote221 views1 answer
R dbConnect(odbc::odbc() to ms sql server remote
SQL
0 vote174 views1 answer
Create table if not exist with exceptions
SQL
-1 vote227 views1 answer
Install mysql 5.7 ubuntu 20.04
SQL
1 vote194 views1 answer
Mysql drop key
SQL
9 votes184 views4 answers
How to create new user and database postgresql in ubuntu
SQL
1 vote172 views1 answer
Mysql get character set
SQL
0 vote146 views1 answer
Mariadb list tables
SQL
0 vote175 views1 answer
How can I tell how many Cores SQL Server is actually using?
SQL
2 votes206 views2 answers
Install postgresql
SQL