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

4 votes164 views1 answer
Oracle show error line number
SQL
0 vote179 views1 answer
Close sql query vb.net
SQL
0 vote185 views1 answer
Drop CHECK constraint sql
SQL
0 vote177 views5 answers
Select concat alter table mysql
SQL
0 vote162 views1 answer
Hallo
SQL
0 vote178 views1 answer
Selecting Data in SQL - Select Data
SQL
0 vote179 views1 answer
Basic structure of sql expression having clause
SQL
0 vote186 views1 answer
Error in connection_import_file(conn@ptr, name, value, sep, eol, skip) : RS_sqlite_import: test.csv line 2 expected 11 columns of data but found 1
SQL
0 vote188 views2 answers
How to create a table from another table in sql derby
SQL
2 votes187 views4 answers
Mysql get all tables row count
SQL