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

8 votes113 views2 answers
Mysql grant all privileges to user from any host
SQL
0 vote123 views1 answer
Rename view mysql
SQL
1 vote119 views3 answers
Epoch to datetime
SQL
3 votes114 views3 answers
C# sql select
SQL
5 votes134 views2 answers
Get columns number sql
SQL
0 vote130 views1 answer
Mysql remove bad character from all fields
SQL
0 vote126 views1 answer
Create a sql server database programmatically
SQL
8 votes109 views3 answers
Postgresql connection string c#
SQL
1 vote103 views1 answer
Sql server 2016 reseed identity
SQL
0 vote115 views1 answer
Data structures in sql
SQL