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 vote145 views1 answer
Postgres list all stored procedures query
SQL
1 vote101 views1 answer
Primary key with prefix sql
SQL
0 vote108 views1 answer
Mostrar datos de tablas relacionadas mysql kjava
SQL
0 vote116 views1 answer
Mssql + bit + in python orm
SQL
0 vote102 views1 answer
Sql server get date of previous sunday
SQL
0 vote100 views1 answer
Declare date variable sql
SQL
26 votes341 views6 answers
Modify column name in sql
SQL
3 votes172 views2 answers
Savepoint in sql
SQL
1 vote100 views1 answer
Clear screen command in psql
SQL
3 votes114 views1 answer
Sql calculate working days between two dates excluding weekends and holidays
SQL