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

2 votes306 views1 answer
Mysql Incorrect column specifier for column
SQL
0 vote310 views3 answers
Delete in SQL SERVER
SQL
0 vote294 views2 answers
Drop check constraint in ms sql
SQL
0 vote352 views2 answers
Mysql cast to varchar
SQL
0 vote292 views1 answer
Count the table indatabase
SQL
1 vote293 views1 answer
Count of tables in database mysql
SQL
0 vote322 views1 answer
Insert into Select * - NAYCode.com
SQL
0 vote305 views2 answers
Tsql row number
SQL
0 vote318 views1 answer
Oracle locked objects
SQL
0 vote308 views1 answer
Create database like
SQL