SQL Server 2019 (Linux)

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

SELECT GETDATE() AS CurrentDateTime, 'yyyy-MM-dd hh:mm:ss tt' AS FormatOption, FORMAT(GETDATE(), 'yyyy-MM-dd hh:mm:ss tt') AS StyleOutput
UNION ALL
SELECT GETDATE() AS CurrentDateTime, 'yyyyMMddHHmmss', FORMAT(GETDATE(), 'yyyyMMddHHmmss')
UNION ALL
SELECT GETDATE(), 'MM/dd/yy', FORMAT(GETDATE(), 'MM/dd/yy')
UNION ALL
SELECT GETDATE(), 'yy.MM.dd', FORMAT(GETDATE(), 'yy.MM.dd')
UNION ALL
SELECT GETDATE(), 'dd/MM/yy', FORMAT(GETDATE(), 'dd/MM/yy')
UNION ALL
SELECT GETDATE(), 'dd.MM.yy', FORMAT(GETDATE(), 'dd.MM.yy')
UNION ALL
SELECT GETDATE(), 'dd-MM-yy', FORMAT(GETDATE(), 'dd-MM-yy')
UNION ALL
SELECT GETDATE(), 'dd MMM yy', FORMAT(GETDATE(), 'dd MMM yy')
UNION ALL
SELECT GETDATE(), 'MMM dd, yy', FORMAT(GETDATE(), 'MMM dd, yy')
UNION ALL
SELECT GETDATE(), 'HH:mm:ss', FORMAT(GETDATE(), 'HH:mm:ss')
UNION ALL
SELECT GETDATE(), 'MMM dd yyyy HH:mm:ss tt', FORMAT(GETDATE(), 'MMM dd yyyy HH:mm:ss tt')
UNION ALL
SELECT GETDATE(), 'MM-dd-yy', FORMAT(GETDATE(), 'MM-dd-yy')
UNION ALL
SELECT GETDATE(), 'yy/MM/dd', FORMAT(GETDATE(), 'yy/MM/dd')
UNION ALL
SELECT GETDATE(), 'yyyyMMdd', FORMAT(GETDATE(), 'yyyyMMdd')
UNION ALL
SELECT GETDATE(), 'dd MMM yyyy HH:mm:ss', FORMAT(GETDATE(), 'dd MMM yyyy HH:mm:ss')
UNION ALL
SELECT GETDATE(), 'HH:mm:ss.fff', FORMAT(GETDATE(), 'HH:mm:ss.fff')
UNION ALL
SELECT GETDATE(), 'yyyy-MM-dd HH:mm:ss', FORMAT(GETDATE(), 'yyyy-MM-dd HH:mm:ss')
UNION ALL
SELECT GETDATE(), 'yyyy-MM-dd HH:mm:ss.fff', FORMAT(GETDATE(), 'yyyy-MM-dd HH:mm:ss.fff')
UNION ALL
SELECT GETDATE(), 'MM/dd/yyyy hh:mm:ss tt', FORMAT(GETDATE(), 'MM/dd/yyyy hh:mm:ss tt')
UNION ALL
SELECT GETDATE(), 'yyyy-MM-dd', FORMAT(GETDATE(), 'yyyy-MM-dd')
UNION ALL
SELECT GETDATE(), 'dd/MM/yyyy', FORMAT(GETDATE(), 'dd/MM/yyyy')
UNION ALL
SELECT GETDATE(), 'dd.MM.yyyy', FORMAT(GETDATE(), 'dd.MM.yyyy')
UNION ALL
SELECT GETDATE(), 'yyyy.MM.dd', FORMAT(GETDATE(), 'yyyy.MM.dd')
UNION ALL
SELECT GETDATE(), 'dd/MM/yyyy HH:mm:ss', FORMAT(GETDATE(), 'dd/MM/yyyy HH:mm:ss')
UNION ALL
SELECT GETDATE(), 'MMM dd yyyy HH:mm:ss tt', FORMAT(GETDATE(), 'MMM dd yyyy HH:mm:ss tt')
UNION ALL
SELECT GETDATE(), 'MM/dd/yyyy', FORMAT(GETDATE(), 'MM/dd/yyyy')
UNION ALL
SELECT GETDATE(), 'yyyy.MM.dd', FORMAT(GETDATE(), 'yyyy.MM.dd')
UNION ALL
SELECT GETDATE(), 'dd/MM/yyyy', FORMAT(GETDATE(), 'dd/MM/yyyy')
UNION ALL
SELECT GETDATE(), 'dd.MM.yyyy', FORMAT(GETDATE(), 'dd.MM.yyyy')
UNION ALL
SELECT GETDATE(), 'dd-MM-yyyy', FORMAT(GETDATE(), 'dd-MM-yyyy')
UNION ALL
SELECT GETDATE(), 'dd MMM yyyy', FORMAT(GETDATE(), 'dd MMM yyyy')
UNION ALL
SELECT GETDATE(), 'MMM dd, yyyy', FORMAT(GETDATE(), 'MMM dd, yyyy')
UNION ALL
SELECT GETDATE(), 'HH:mm:ss', FORMAT(GETDATE(), 'HH:mm:ss')
UNION ALL
SELECT GETDATE(), 'MMM dd yyyy HH:mm:ss tt', FORMAT(GETDATE(), 'MMM dd yyyy HH:mm:ss tt')
UNION ALL
SELECT GETDATE(), 'MM-dd-yyyy', FORMAT(GETDATE(), 'MM-dd-yyyy')
UNION ALL
SELECT GETDATE(), 'yyyy/MM/dd', FORMAT(GETDATE(), 'yyyy/MM/dd')
UNION ALL
SELECT GETDATE(), 'yyyyMMdd', FORMAT(GETDATE(), 'yyyyMMdd')
UNION ALL
SELECT GETDATE(), 'dd MMM yyyy HH:mm:ss', FORMAT(GETDATE(), 'dd MMM yyyy HH:mm:ss')
UNION ALL
SELECT GETDATE(), 'HH:mm:ss.fff', FORMAT(GETDATE(), 'HH:mm:ss.fff')
UNION ALL
SELECT GETDATE(), 'yyyy-MM-dd HH:mm:ss', FORMAT(GETDATE(), 'yyyy-MM-dd HH:mm:ss')
UNION ALL
SELECT GETDATE(), 'yyyy-MM-dd HH:mm:ss.fff', FORMAT(GETDATE(), 'yyyy-MM-dd HH:mm:ss.fff')
UNION ALL
SELECT GETDATE(), 'yyyy-MM-ddTHH:mm:ss.fff', FORMAT(GETDATE(), 'yyyy-MM-ddTHH:mm:ss.fff')
UNION ALL
SELECT GETDATE(), 'dd MMM yyyy HH:mm:ss.fff tt', FORMAT(GETDATE(), 'dd MMM yyyy HH:mm:ss.fff tt')
UNION ALL
SELECT GETDATE(), 'dd/MM/yyyy HH:mm:ss.fff tt', FORMAT(GETDATE(), 'dd/MM/yyyy HH:mm:ss.fff tt');

CurrentDateTime	FormatOption	StyleOutput
2024-07-29 01:46:41.423	yyyy-MM-dd hh:mm:ss tt	2024-07-29 01:46:41 AM
2024-07-29 01:46:41.503	yyyyMMddHHmmss	20240729014641
2024-07-29 01:46:41.503	MM/dd/yy	07/29/24
2024-07-29 01:46:41.503	yy.MM.dd	24.07.29
2024-07-29 01:46:41.503	dd/MM/yy	29/07/24
2024-07-29 01:46:41.503	dd.MM.yy	29.07.24
2024-07-29 01:46:41.507	dd-MM-yy	29-07-24
2024-07-29 01:46:41.507	dd MMM yy	29 Jul 24
2024-07-29 01:46:41.620	MMM dd, yy	Jul 29, 24
2024-07-29 01:46:41.620	HH:mm:ss	01:46:41
2024-07-29 01:46:41.620	MMM dd yyyy HH:mm:ss tt	Jul 29 2024 01:46:41 AM
2024-07-29 01:46:41.620	MM-dd-yy	07-29-24
2024-07-29 01:46:41.620	yy/MM/dd	24/07/29
2024-07-29 01:46:41.620	yyyyMMdd	20240729
2024-07-29 01:46:41.620	dd MMM yyyy HH:mm:ss	29 Jul 2024 01:46:41
2024-07-29 01:46:41.620	HH:mm:ss.fff	01:46:41.620
2024-07-29 01:46:41.623	yyyy-MM-dd HH:mm:ss	2024-07-29 01:46:41
2024-07-29 01:46:41.623	yyyy-MM-dd HH:mm:ss.fff	2024-07-29 01:46:41.623
2024-07-29 01:46:41.630	MM/dd/yyyy hh:mm:ss tt	07/29/2024 01:46:41 AM
2024-07-29 01:46:41.630	yyyy-MM-dd	2024-07-29
2024-07-29 01:46:41.630	dd/MM/yyyy	29/07/2024
2024-07-29 01:46:41.630	dd.MM.yyyy	29.07.2024
2024-07-29 01:46:41.630	yyyy.MM.dd	2024.07.29
2024-07-29 01:46:41.630	dd/MM/yyyy HH:mm:ss	29/07/2024 01:46:41
2024-07-29 01:46:41.630	MMM dd yyyy HH:mm:ss tt	Jul 29 2024 01:46:41 AM
2024-07-29 01:46:41.630	MM/dd/yyyy	07/29/2024
2024-07-29 01:46:41.633	yyyy.MM.dd	2024.07.29
2024-07-29 01:46:41.633	dd/MM/yyyy	29/07/2024
2024-07-29 01:46:41.633	dd.MM.yyyy	29.07.2024
2024-07-29 01:46:41.633	dd-MM-yyyy	29-07-2024
2024-07-29 01:46:41.633	dd MMM yyyy	29 Jul 2024
2024-07-29 01:46:41.633	MMM dd, yyyy	Jul 29, 2024
2024-07-29 01:46:41.633	HH:mm:ss	01:46:41
2024-07-29 01:46:41.633	MMM dd yyyy HH:mm:ss tt	Jul 29 2024 01:46:41 AM
2024-07-29 01:46:41.633	MM-dd-yyyy	07-29-2024
2024-07-29 01:46:41.633	yyyy/MM/dd	2024/07/29
2024-07-29 01:46:41.633	yyyyMMdd	20240729
2024-07-29 01:46:41.633	dd MMM yyyy HH:mm:ss	29 Jul 2024 01:46:41
2024-07-29 01:46:41.633	HH:mm:ss.fff	01:46:41.633
2024-07-29 01:46:41.633	yyyy-MM-dd HH:mm:ss	2024-07-29 01:46:41
2024-07-29 01:46:41.633	yyyy-MM-dd HH:mm:ss.fff	2024-07-29 01:46:41.633
2024-07-29 01:46:41.633	yyyy-MM-ddTHH:mm:ss.fff	2024-07-29T01:46:41.633
2024-07-29 01:46:41.633	dd MMM yyyy HH:mm:ss.fff tt	29 Jul 2024 01:46:41.633 AM
2024-07-29 01:46:41.633	dd/MM/yyyy HH:mm:ss.fff tt	29/07/2024 01:46:41.633 AM

(No column name)
Microsoft SQL Server 2019 (RTM-CU27) (KB5037331) - 15.0.4375.4 (X64) Jun 10 2024 18:00:07 Copyright (C) 2019 Microsoft Corporation Express Edition (64-bit) on Linux (Rocky Linux 8.10 (Green Obsidian)) <X64>