SQL Server Date Formats

by Yavuz Selim Kart · Published 27 October 2021 · Updated 23 March 2023

Hello to everyone,

In this article, I will talk about Date format change operations in SQL Server.

Date format change is often used in SQL Server.

You can use the codes below to change the date format.

1	`SELECT CONVERT(VARCHAR, GETDATE(), 1);`	mm/dd/yy	12/30/06
2	`SELECT CONVERT(VARCHAR, GETDATE(), 2);`	yy.mm.dd	06.12.30
3	`SELECT CONVERT(VARCHAR, GETDATE(), 3);`	dd/mm/yy	30/12/06
4	`select convert(varchar, getdate(), 4)`	dd.mm.yy	30.12.06
5	`SELECT CONVERT(VARCHAR, GETDATE(), 4);`	dd-mm-yy	30-12-06
6	`SELECT CONVERT(VARCHAR, GETDATE(), 6);`	dd-Mon-yy	30 Dec 06
7	`SELECT CONVERT(VARCHAR, GETDATE(), 7);`	Mon dd, yy	Dec 30, 06
10	`SELECT CONVERT(VARCHAR, GETDATE(), 10);`	mm-dd-yy	12-30-06
11	`SELECT CONVERT(VARCHAR, GETDATE(), 11);`	yy/mm/dd	06/12/30
12	`SELECT CONVERT(VARCHAR, GETDATE(), 12);`	yymmdd	061230
23	`SELECT CONVERT(VARCHAR, GETDATE(), 23);`	yyyy-mm-dd	2006-12-30
101	`SELECT CONVERT(VARCHAR, GETDATE(), 101);`	mm/dd/yyyy	12/30/2006
102	`SELECT CONVERT(VARCHAR, GETDATE(), 102);`	yyyy.mm.dd	2006.12.30
103	`SELECT CONVERT(VARCHAR, GETDATE(), 103);`	dd/mm/yyyy	30/12/2006
104	`SELECT CONVERT(VARCHAR, GETDATE(), 104);`	dd.mm.yyyy	30.12.2006
105	`SELECT CONVERT(VARCHAR, GETDATE(), 105);`	dd-mm-yyyy	30-12-2006
106	`SELECT CONVERT(VARCHAR, GETDATE(), 106);`	dd Mon yyyy	30 Dec 2006
107	`SELECT CONVERT(VARCHAR, GETDATE(), 107);`	Mon dd, yyyy	Dec 30, 2006
110	`SELECT CONVERT(VARCHAR, GETDATE(), 110);`	mm-dd-yyyy	12-30-2006
111	`SELECT CONVERT(VARCHAR, GETDATE(), 111);`	yyyy/mm/dd	2006/12/30
112	`SELECT CONVERT(VARCHAR, GETDATE(), 112);`	yyyymmdd	20061230

When you run the code, you will get a result like the one below.

SQL Server Date Formats

As you can see, the date values have been changed in a formatted way.

Good luck to everyone in business and life

258 Views