SQL Server 2019 (Linux)

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

SELECT GETDATE() AS CurrentDateTime,
       CONVERT(VARCHAR(10), GETDATE(), 120) AS [yyyy-MM-dd]


CurrentDateTime
yyyy-MM-dd


2023-08-18 17:31:28.203
2023-08-18


SELECT GETDATE() AS CurrentDateTime,
       CONVERT(VARCHAR, GETDATE(), 112) AS yyyyMMdd


CurrentDateTime
yyyyMMdd


2023-08-18 17:31:28.203
20230818


SELECT GETDATE() AS CurrentDateTime,
       REPLACE(REPLACE(REPLACE(CONVERT(VARCHAR, GETDATE(), 120), ':', ''), '-', ''), ' ', '') AS yyyyMMddHHmmss


CurrentDateTime
yyyyMMddHHmmss


2023-08-18 17:31:28.207
20230818173128


DECLARE @counter INT = 0;
DECLARE @current_datetime DATETIME = GETDATE();

DROP TABLE

IF EXISTS #FormatDateDemo
	CREATE TABLE #FormatDateDemo (
		StyleNumber INT
		,StyleOutput NVARCHAR(40)
		,Query NVARCHAR(100)
		);

WHILE (@counter <= 131)
BEGIN
	BEGIN TRY
		INSERT INTO #FormatDateDemo
		SELECT @counter AS StyleNumber
			,CONVERT(NVARCHAR, @current_datetime, @counter) AS StyleOutput
			,CONCAT (
				'SELECT CONVERT(NVARCHAR, GETDATE(), '
				,CONVERT(NVARCHAR, @counter)
				,')'
				) AS Query;

		SET @counter = @counter + 1;
	END TRY

	BEGIN CATCH
		SET @counter = @counter + 1;
	END CATCH
END

SELECT @current_datetime AS CurrentDateTime
	,*
FROM #FormatDateDemo;


CurrentDateTime
StyleNumber
StyleOutput
Query


2023-08-18 17:31:28.207
0
Aug 18 2023  5:31PM
SELECT CONVERT(NVARCHAR, GETDATE(), 0)

2023-08-18 17:31:28.207
1
08/18/23
SELECT CONVERT(NVARCHAR, GETDATE(), 1)

2023-08-18 17:31:28.207
2
23.08.18
SELECT CONVERT(NVARCHAR, GETDATE(), 2)

2023-08-18 17:31:28.207
3
18/08/23
SELECT CONVERT(NVARCHAR, GETDATE(), 3)

2023-08-18 17:31:28.207
4
18.08.23
SELECT CONVERT(NVARCHAR, GETDATE(), 4)

2023-08-18 17:31:28.207
5
18-08-23
SELECT CONVERT(NVARCHAR, GETDATE(), 5)

2023-08-18 17:31:28.207
6
18 Aug 23
SELECT CONVERT(NVARCHAR, GETDATE(), 6)

2023-08-18 17:31:28.207
7
Aug 18, 23
SELECT CONVERT(NVARCHAR, GETDATE(), 7)

2023-08-18 17:31:28.207
8
17:31:28
SELECT CONVERT(NVARCHAR, GETDATE(), 8)

2023-08-18 17:31:28.207
9
Aug 18 2023  5:31:28:207PM
SELECT CONVERT(NVARCHAR, GETDATE(), 9)

2023-08-18 17:31:28.207
10
08-18-23
SELECT CONVERT(NVARCHAR, GETDATE(), 10)

2023-08-18 17:31:28.207
11
23/08/18
SELECT CONVERT(NVARCHAR, GETDATE(), 11)

2023-08-18 17:31:28.207
12
230818
SELECT CONVERT(NVARCHAR, GETDATE(), 12)

2023-08-18 17:31:28.207
13
18 Aug 2023 17:31:28:207
SELECT CONVERT(NVARCHAR, GETDATE(), 13)

2023-08-18 17:31:28.207
14
17:31:28:207
SELECT CONVERT(NVARCHAR, GETDATE(), 14)

2023-08-18 17:31:28.207
20
2023-08-18 17:31:28
SELECT CONVERT(NVARCHAR, GETDATE(), 20)

2023-08-18 17:31:28.207
21
2023-08-18 17:31:28.207
SELECT CONVERT(NVARCHAR, GETDATE(), 21)

2023-08-18 17:31:28.207
22
08/18/23  5:31:28 PM
SELECT CONVERT(NVARCHAR, GETDATE(), 22)

2023-08-18 17:31:28.207
23
2023-08-18
SELECT CONVERT(NVARCHAR, GETDATE(), 23)

2023-08-18 17:31:28.207
24
17:31:28
SELECT CONVERT(NVARCHAR, GETDATE(), 24)

2023-08-18 17:31:28.207
25
2023-08-18 17:31:28.207
SELECT CONVERT(NVARCHAR, GETDATE(), 25)

2023-08-18 17:31:28.207
26
2023-18-08 17:31:28.207
SELECT CONVERT(NVARCHAR, GETDATE(), 26)

2023-08-18 17:31:28.207
27
08-18-2023 17:31:28.207
SELECT CONVERT(NVARCHAR, GETDATE(), 27)

2023-08-18 17:31:28.207
28
08-2023-18 17:31:28.207
SELECT CONVERT(NVARCHAR, GETDATE(), 28)

2023-08-18 17:31:28.207
29
18-08-2023 17:31:28.207
SELECT CONVERT(NVARCHAR, GETDATE(), 29)

2023-08-18 17:31:28.207
30
18-2023-08 17:31:28.207
SELECT CONVERT(NVARCHAR, GETDATE(), 30)

2023-08-18 17:31:28.207
31
2023-18-08
SELECT CONVERT(NVARCHAR, GETDATE(), 31)

2023-08-18 17:31:28.207
32
08-18-2023
SELECT CONVERT(NVARCHAR, GETDATE(), 32)

2023-08-18 17:31:28.207
33
08-2023-18
SELECT CONVERT(NVARCHAR, GETDATE(), 33)

2023-08-18 17:31:28.207
34
18-08-2023
SELECT CONVERT(NVARCHAR, GETDATE(), 34)

2023-08-18 17:31:28.207
35
18-2023-08
SELECT CONVERT(NVARCHAR, GETDATE(), 35)

2023-08-18 17:31:28.207
100
Aug 18 2023  5:31PM
SELECT CONVERT(NVARCHAR, GETDATE(), 100)

2023-08-18 17:31:28.207
101
08/18/2023
SELECT CONVERT(NVARCHAR, GETDATE(), 101)

2023-08-18 17:31:28.207
102
2023.08.18
SELECT CONVERT(NVARCHAR, GETDATE(), 102)

2023-08-18 17:31:28.207
103
18/08/2023
SELECT CONVERT(NVARCHAR, GETDATE(), 103)

2023-08-18 17:31:28.207
104
18.08.2023
SELECT CONVERT(NVARCHAR, GETDATE(), 104)

2023-08-18 17:31:28.207
105
18-08-2023
SELECT CONVERT(NVARCHAR, GETDATE(), 105)

2023-08-18 17:31:28.207
106
18 Aug 2023
SELECT CONVERT(NVARCHAR, GETDATE(), 106)

2023-08-18 17:31:28.207
107
Aug 18, 2023
SELECT CONVERT(NVARCHAR, GETDATE(), 107)

2023-08-18 17:31:28.207
108
17:31:28
SELECT CONVERT(NVARCHAR, GETDATE(), 108)

2023-08-18 17:31:28.207
109
Aug 18 2023  5:31:28:207PM
SELECT CONVERT(NVARCHAR, GETDATE(), 109)

2023-08-18 17:31:28.207
110
08-18-2023
SELECT CONVERT(NVARCHAR, GETDATE(), 110)

2023-08-18 17:31:28.207
111
2023/08/18
SELECT CONVERT(NVARCHAR, GETDATE(), 111)

2023-08-18 17:31:28.207
112
20230818
SELECT CONVERT(NVARCHAR, GETDATE(), 112)

2023-08-18 17:31:28.207
113
18 Aug 2023 17:31:28:207
SELECT CONVERT(NVARCHAR, GETDATE(), 113)

2023-08-18 17:31:28.207
114
17:31:28:207
SELECT CONVERT(NVARCHAR, GETDATE(), 114)

2023-08-18 17:31:28.207
120
2023-08-18 17:31:28
SELECT CONVERT(NVARCHAR, GETDATE(), 120)

2023-08-18 17:31:28.207
121
2023-08-18 17:31:28.207
SELECT CONVERT(NVARCHAR, GETDATE(), 121)

2023-08-18 17:31:28.207
126
2023-08-18T17:31:28.207
SELECT CONVERT(NVARCHAR, GETDATE(), 126)

2023-08-18 17:31:28.207
127
2023-08-18T17:31:28.207
SELECT CONVERT(NVARCHAR, GETDATE(), 127)

2023-08-18 17:31:28.207
130
 2 صفر 1445  5:31:28:207PM
SELECT CONVERT(NVARCHAR, GETDATE(), 130)

2023-08-18 17:31:28.207
131
 2/02/1445  5:31:28:207PM
SELECT CONVERT(NVARCHAR, GETDATE(), 131)

CurrentDateTime	StyleNumber	StyleOutput	Query
2023-08-18 17:31:28.207	0	Aug 18 2023 5:31PM	SELECT CONVERT(NVARCHAR, GETDATE(), 0)
2023-08-18 17:31:28.207	1	08/18/23	SELECT CONVERT(NVARCHAR, GETDATE(), 1)
2023-08-18 17:31:28.207	2	23.08.18	SELECT CONVERT(NVARCHAR, GETDATE(), 2)
2023-08-18 17:31:28.207	3	18/08/23	SELECT CONVERT(NVARCHAR, GETDATE(), 3)
2023-08-18 17:31:28.207	4	18.08.23	SELECT CONVERT(NVARCHAR, GETDATE(), 4)
2023-08-18 17:31:28.207	5	18-08-23	SELECT CONVERT(NVARCHAR, GETDATE(), 5)
2023-08-18 17:31:28.207	6	18 Aug 23	SELECT CONVERT(NVARCHAR, GETDATE(), 6)
2023-08-18 17:31:28.207	7	Aug 18, 23	SELECT CONVERT(NVARCHAR, GETDATE(), 7)
2023-08-18 17:31:28.207	8	17:31:28	SELECT CONVERT(NVARCHAR, GETDATE(), 8)
2023-08-18 17:31:28.207	9	Aug 18 2023 5:31:28:207PM	SELECT CONVERT(NVARCHAR, GETDATE(), 9)
2023-08-18 17:31:28.207	10	08-18-23	SELECT CONVERT(NVARCHAR, GETDATE(), 10)
2023-08-18 17:31:28.207	11	23/08/18	SELECT CONVERT(NVARCHAR, GETDATE(), 11)
2023-08-18 17:31:28.207	12	230818	SELECT CONVERT(NVARCHAR, GETDATE(), 12)
2023-08-18 17:31:28.207	13	18 Aug 2023 17:31:28:207	SELECT CONVERT(NVARCHAR, GETDATE(), 13)
2023-08-18 17:31:28.207	14	17:31:28:207	SELECT CONVERT(NVARCHAR, GETDATE(), 14)
2023-08-18 17:31:28.207	20	2023-08-18 17:31:28	SELECT CONVERT(NVARCHAR, GETDATE(), 20)
2023-08-18 17:31:28.207	21	2023-08-18 17:31:28.207	SELECT CONVERT(NVARCHAR, GETDATE(), 21)
2023-08-18 17:31:28.207	22	08/18/23 5:31:28 PM	SELECT CONVERT(NVARCHAR, GETDATE(), 22)
2023-08-18 17:31:28.207	23	2023-08-18	SELECT CONVERT(NVARCHAR, GETDATE(), 23)
2023-08-18 17:31:28.207	24	17:31:28	SELECT CONVERT(NVARCHAR, GETDATE(), 24)
2023-08-18 17:31:28.207	25	2023-08-18 17:31:28.207	SELECT CONVERT(NVARCHAR, GETDATE(), 25)
2023-08-18 17:31:28.207	26	2023-18-08 17:31:28.207	SELECT CONVERT(NVARCHAR, GETDATE(), 26)
2023-08-18 17:31:28.207	27	08-18-2023 17:31:28.207	SELECT CONVERT(NVARCHAR, GETDATE(), 27)
2023-08-18 17:31:28.207	28	08-2023-18 17:31:28.207	SELECT CONVERT(NVARCHAR, GETDATE(), 28)
2023-08-18 17:31:28.207	29	18-08-2023 17:31:28.207	SELECT CONVERT(NVARCHAR, GETDATE(), 29)
2023-08-18 17:31:28.207	30	18-2023-08 17:31:28.207	SELECT CONVERT(NVARCHAR, GETDATE(), 30)
2023-08-18 17:31:28.207	31	2023-18-08	SELECT CONVERT(NVARCHAR, GETDATE(), 31)
2023-08-18 17:31:28.207	32	08-18-2023	SELECT CONVERT(NVARCHAR, GETDATE(), 32)
2023-08-18 17:31:28.207	33	08-2023-18	SELECT CONVERT(NVARCHAR, GETDATE(), 33)
2023-08-18 17:31:28.207	34	18-08-2023	SELECT CONVERT(NVARCHAR, GETDATE(), 34)
2023-08-18 17:31:28.207	35	18-2023-08	SELECT CONVERT(NVARCHAR, GETDATE(), 35)
2023-08-18 17:31:28.207	100	Aug 18 2023 5:31PM	SELECT CONVERT(NVARCHAR, GETDATE(), 100)
2023-08-18 17:31:28.207	101	08/18/2023	SELECT CONVERT(NVARCHAR, GETDATE(), 101)
2023-08-18 17:31:28.207	102	2023.08.18	SELECT CONVERT(NVARCHAR, GETDATE(), 102)
2023-08-18 17:31:28.207	103	18/08/2023	SELECT CONVERT(NVARCHAR, GETDATE(), 103)
2023-08-18 17:31:28.207	104	18.08.2023	SELECT CONVERT(NVARCHAR, GETDATE(), 104)
2023-08-18 17:31:28.207	105	18-08-2023	SELECT CONVERT(NVARCHAR, GETDATE(), 105)
2023-08-18 17:31:28.207	106	18 Aug 2023	SELECT CONVERT(NVARCHAR, GETDATE(), 106)
2023-08-18 17:31:28.207	107	Aug 18, 2023	SELECT CONVERT(NVARCHAR, GETDATE(), 107)
2023-08-18 17:31:28.207	108	17:31:28	SELECT CONVERT(NVARCHAR, GETDATE(), 108)
2023-08-18 17:31:28.207	109	Aug 18 2023 5:31:28:207PM	SELECT CONVERT(NVARCHAR, GETDATE(), 109)
2023-08-18 17:31:28.207	110	08-18-2023	SELECT CONVERT(NVARCHAR, GETDATE(), 110)
2023-08-18 17:31:28.207	111	2023/08/18	SELECT CONVERT(NVARCHAR, GETDATE(), 111)
2023-08-18 17:31:28.207	112	20230818	SELECT CONVERT(NVARCHAR, GETDATE(), 112)
2023-08-18 17:31:28.207	113	18 Aug 2023 17:31:28:207	SELECT CONVERT(NVARCHAR, GETDATE(), 113)
2023-08-18 17:31:28.207	114	17:31:28:207	SELECT CONVERT(NVARCHAR, GETDATE(), 114)
2023-08-18 17:31:28.207	120	2023-08-18 17:31:28	SELECT CONVERT(NVARCHAR, GETDATE(), 120)
2023-08-18 17:31:28.207	121	2023-08-18 17:31:28.207	SELECT CONVERT(NVARCHAR, GETDATE(), 121)
2023-08-18 17:31:28.207	126	2023-08-18T17:31:28.207	SELECT CONVERT(NVARCHAR, GETDATE(), 126)
2023-08-18 17:31:28.207	127	2023-08-18T17:31:28.207	SELECT CONVERT(NVARCHAR, GETDATE(), 127)
2023-08-18 17:31:28.207	130	2 صفر 1445 5:31:28:207PM	SELECT CONVERT(NVARCHAR, GETDATE(), 130)
2023-08-18 17:31:28.207	131	2/02/1445 5:31:28:207PM	SELECT CONVERT(NVARCHAR, GETDATE(), 131)