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 vote183 views1 answer
Parsing float to int in mysql
SQL
2 votes207 views1 answer
Drop all foreign key constraints mysql
SQL
3 votes254 views1 answer
Mysql group_concat distinct
SQL
0 vote185 views1 answer
Select in select sql
SQL
12 votes185 views3 answers
Install sqlite driver ubuntu
SQL
3 votes185 views1 answer
Two selects in one query
SQL
0 vote232 views1 answer
UNION ALL LEFT JOIN
SQL
1 vote179 views1 answer
Floor function in sql oracle
SQL
0 vote215 views1 answer
Selecting all columns from table sql database
SQL
0 vote218 views1 answer
How much space does sql server take per row
SQL