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 votes245 views2 answers
Union vs union all in sql
SQL
1 vote250 views1 answer
Continue in sql
SQL
1 vote259 views3 answers
How to pass password to mysql command line
SQL
4 votes187 views1 answer
And or sql order of operations
SQL
8 votes242 views1 answer
Oracle tablespace datafile max size
SQL
3 votes226 views3 answers
How to set up an auto incrementing id db browser
SQL
0 vote225 views1 answer
Sql orcale i forgot what my name & password was
SQL
18 votes240 views6 answers
Laravel form validation
SQL
3 votes243 views1 answer
Postgres add not null to existing column
SQL
0 vote227 views1 answer
Mysql start of today
SQL