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 vote184 views1 answer
How to alter length character varying postgres
SQL
1 vote185 views2 answers
Postgresql check privileges on schema
SQL
3 votes223 views2 answers
Enter mysql command line
SQL
0 vote133 views2 answers
Https://www.google.com/search?ei=bihqX_v9DJb--gTYoLH4DQ
SQL
1 vote168 views1 answer
Postgresql reset serial counter after deleting content
SQL
0 vote272 views1 answer
Sql alchemy escape ; in insert statement
SQL
3 votes166 views1 answer
Oracle APEX elapsed time
SQL
0 vote168 views1 answer
Sql server 2012 create or alter procedure
SQL
1 vote171 views1 answer
Drop df constraint sql server
SQL
0 vote183 views1 answer
Sql where time stamp is in between
SQL