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

3 votes207 views2 answers
How to delete git repo locally
SQL
0 vote181 views1 answer
Sql query to check if column contains alphabets
SQL
0 vote186 views1 answer
Copied text from internet not inserting in mysql
SQL
0 vote192 views1 answer
Sqlite higher or equal
SQL
0 vote190 views1 answer
Sql server information_schema temp tables
SQL
15 votes342 views2 answers
How to sort names in alphabetical order in sql
SQL
0 vote215 views2 answers
How to truncate all table in mysql workbench
SQL
0 vote222 views1 answer
Oracle plsql sleep
SQL
0 vote211 views1 answer
Sql dmv to capture updates
SQL
0 vote190 views1 answer
Drop constraint in ms sql
SQL