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 vote289 views1 answer
Create table with timestamp mysql youtube
SQL
7 votes305 views2 answers
Mysql Public Key Retrieval is not allowed
SQL
1 vote306 views3 answers
Alter schema sql server
SQL
0 vote280 views1 answer
MySql Modify Increment
SQL
0 vote300 views1 answer
Search mysql database for column
SQL
0 vote281 views1 answer
Bus source and destination equal to destination and source of another by sql query
SQL
0 vote342 views1 answer
Drop view sql
SQL
7 votes295 views3 answers
Python and mysql connectivity
SQL
1 vote302 views1 answer
Oracle select row max date
SQL
0 vote285 views1 answer
View to table
SQL