/SQL/Convert ansi sql

Convert ansi sql

Sql server convert string to date

select Cast( '2021-09-22' as date ) as castedDate;
select convert(date,'20210922') as convertedDate;

7

Convert ansi sql

select *
  from test a, test b
  where a.t = b.t (+)

0

Convert ansi sql

select *
  from test a, test b
  where a.t = b.t (+)

0

Similar codes

1 vote196 views1 answer
Sql server get users
SQL
0 vote184 views1 answer
Nueva tabla mysql
SQL
10 votes187 views2 answers
Mysql drop database if exists
SQL
0 vote167 views1 answer
Oracle list of long running queries
SQL
10 votes127 views1 answer
Oracle view dependencies
SQL
1 vote176 views1 answer
Sql server find tables referenced foreign key
SQL
0 vote191 views1 answer
Configure MYSQL to run on another port number, other than the default port 3306 ubuntu linux
SQL
0 vote175 views1 answer
Table or view does not exist
SQL
0 vote181 views2 answers
Sql server Insert Into table
SQL
2 votes176 views1 answer
Oracle table size
SQL

Share