/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 vote172 views1 answer
Ssql to lowercqse
SQL
0 vote226 views2 answers
Uninstall postgresql mac
SQL
1 vote178 views3 answers
Reset sql primary key
SQL
6 votes219 views1 answer
Identify primary key in oracle table
SQL
0 vote183 views1 answer
Tsql pad left
SQL
4 votes164 views3 answers
Create database in mySQL
SQL
6 votes263 views3 answers
POSTGRES INSERT INTO TABLE VALUE FROM OTHER TABLE
SQL
0 vote168 views1 answer
Data structures in sql
SQL
7 votes204 views1 answer
Alter sequence set current value oracle
SQL
2 votes194 views1 answer
Import large .sql files into lampp
SQL

Share