/SQL/Convert date to dd/mm/yyyy sql

Convert date to dd/mm/yyyy sql

Sql server convert string to date

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

7

Convert date to dd/mm/yyyy sql

select CONVERT(char(10), GetDate(),103)
/* 30/06/2021 */

2

Sql convert date to string yyyy-mm-dd

select CONVERT(char(10), GetDate(),126)
/* 2020-12-23 */

0

SQL query to convert DD/MM/YYYY to YYYY-MM-DD

SELECT CONVERT(varchar(10), CONVERT(date, '13/12/2016', 103), 120)

-1

Source: social.technet.microsoft.com

Similar codes

-1 vote234 views1 answer
Sql show custom constraints
SQL
19 votes213 views6 answers
Sql create table
SQL
0 vote212 views1 answer
Syntax for changing column size in mysql
SQL
7 votes222 views6 answers
Nth highest salary in sql
SQL
7 votes267 views3 answers
Sql server check if temp table exists
SQL
5 votes206 views3 answers
Sql make column nullable
SQL
0 vote223 views1 answer
Mysql sum with group by
SQL
1 vote241 views1 answer
What is in condition in sql
SQL
12 votes197 views5 answers
Sql primary key
SQL
-1 vote241 views1 answer
How to Activate the database
SQL

Share