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 vote224 views1 answer
Spark sql convert string to date
SQL
8 votes191 views1 answer
Oracle add month
SQL
1 vote208 views1 answer
Postgresql how to show table names
SQL
0 vote204 views1 answer
Start and stop mysql
SQL
1 vote209 views1 answer
Set statiscis on in ssms
SQL
31 votes210 views3 answers
SQL Server change column data type
SQL
0 vote206 views1 answer
Postgres foreign key multiple columns
SQL
0 vote212 views1 answer
Convert multiple columns to ROws in sql server
SQL
0 vote201 views1 answer
Java spring boot connect to sql server
SQL
0 vote203 views1 answer
Sql not exists
SQL