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 vote141 views1 answer
Mysql cli output to a file
SQL
11 votes135 views4 answers
Query DISTINCT
SQL
1 vote143 views1 answer
Complete output (15 lines): /bin/sh: 1: mysql_config: not found /bin/sh: 1: mariadb_config: not found /bin/sh: 1: mysql_config: not found Traceback (most recent call last): File "<string>", line 1, in <module> File "/tmp/pi
SQL
0 vote129 views1 answer
Alter table fulltext
SQL
0 vote153 views1 answer
Oracle insert single quote in string
SQL
0 vote135 views1 answer
Como hacer una consulta de un registro que no esta en una tabla en mysql
SQL
0 vote158 views1 answer
Count database access django
SQL
1 vote134 views2 answers
String to date postgres
SQL
0 vote175 views1 answer
Install postgresql 12 on debian 10
SQL
5 votes124 views2 answers
Create table
SQL