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 vote197 views1 answer
Java mysql swing example
SQL
5 votes194 views2 answers
Sql create tabel with primary key auto_increment code
SQL
0 vote200 views1 answer
Reona
SQL
-1 vote207 views2 answers
SQL SELECT TOP Equivalent in oracal
SQL
7 votes202 views2 answers
Add column table pl sql
SQL
-1 vote255 views1 answer
MYSQL stored procedure select from
SQL
0 vote195 views1 answer
Alasql delete column
SQL
-1 vote203 views1 answer
What is in operator
SQL
0 vote189 views1 answer
Illuminate\Database\QueryException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'updated_at' in 'field list'
SQL
0 vote194 views1 answer
Java mysql date format
SQL