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 votes348 views6 answers
Laravel jwt
SQL
0 vote234 views1 answer
Query to generate query to drop primary keys or foreign key in ms sql server
SQL
1 vote231 views1 answer
Age postgres
SQL
0 vote218 views1 answer
Plsql check for string in numeric
SQL
0 vote215 views1 answer
Mysql date minus 1 day
SQL
6 votes203 views2 answers
Return columns from table sql
SQL
0 vote224 views1 answer
Test sql query
SQL
0 vote227 views1 answer
Sql get date from timestamp
SQL
2 votes215 views1 answer
Mysql application.properties spring boot
SQL
1 vote219 views1 answer
How to unlock table in mysql
SQL