/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

3 votes196 views2 answers
Truncate all tables
SQL
11 votes202 views1 answer
Sql query to find duplicates in column
SQL
4 votes198 views1 answer
Restart for pg_hba.conf file
SQL
0 vote202 views1 answer
Mysql Like(searching in the string)
SQL
1 vote151 views1 answer
Enable mysql slow query log
SQL
1 vote184 views1 answer
Mysql datetime with timezone offset
SQL
22 votes186 views3 answers
Join three tables sql
SQL
0 vote211 views1 answer
How to run mysql in git bash
SQL
1 vote234 views3 answers
Divide by zero error in sql
SQL
1 vote212 views3 answers
Connection string mysql
SQL

Share