Question : SQL Server format datetime
Answered by : kyle-hill
SELECT FORMAT(CURRENT_TIMESTAMP, 'yyyy-MM-dd hh:mm:ss tt')
Source : https://stackoverflow.com/questions/23837672/how-to-format-datetime-in-sql-server | Last Update : Wed, 30 Jun 21
Question : Date formats in SQL Server
Answered by : rasel-ahmed-9kilyai1mdfd
DATE ONLY FORMATS
select convert(varchar, getdate(), 1); output: 12/30/06 (mm/dd/yy)
select convert(varchar, getdate(), 2); output: 06.12.30 (yy.mm.dd)
select convert(varchar, getdate(), 3); output: 30/12/06 (dd/mm/yy)
select convert(varchar, getdate(), 4); output: 30.12.06 (dd.mm.yy)
select convert(varchar, getdate(), 5); output: 30-12-06 (dd-mm-yy)
select convert(varchar, getdate(), 6); output: 30 Dec 06 (dd-Mon-yy)
select convert(varchar, getdate(), 7); output: Dec 30, 06 (Mon dd, yy)
select convert(varchar, getdate(), 10); output: 12-30-06 (mm-dd-yy)
select convert(varchar, getdate(), 11); output: 06/12/30 (yy/mm/dd)
select convert(varchar, getdate(), 12); output: 061230 (yymmdd)
select convert(varchar, getdate(), 23); output: 2006-12-30 (yyyy-mm-dd)
select convert(varchar, getdate(), 101); output: 12/30/2006 (mm/dd/yyyy)
select convert(varchar, getdate(), 102); output: 2006.12.30 (yyyy.mm.dd)
select convert(varchar, getdate(), 103); output: 30/12/2006 (dd/mm/yyyy)
select convert(varchar, getdate(), 104); output: 30.12.2006 (dd.mm.yyyy)
select convert(varchar, getdate(), 105); output: 30-12-2006 (dd-mm-yyyy)
select convert(varchar, getdate(), 106); output: 30 Dec 2006 (dd Mon yyyy)
select convert(varchar, getdate(), 107); output: Dec 30, 2006 (Mon dd, yyyy)
select convert(varchar, getdate(), 110); output: 12-30-2006 (mm-dd-yyyy)
select convert(varchar, getdate(), 111); output: 2006/12/30 (yyyy/mm/dd)
select convert(varchar, getdate(), 112); output : 20061230 (yyyymmdd)
TIME ONLY FORMATS
select convert(varchar, getdate(), 8); output: 00:38:54 (hh:mm:ss)
select convert(varchar, getdate(), 14); output: 00:38:54:840 (hh:mm:ss:nnn)
select convert(varchar, getdate(), 24); output: 00:38:54 (hh:mm:ss)
select convert(varchar, getdate(), 108); output: 00:38:54 (hh:mm:ss)
select convert(varchar, getdate(), 114); output: 00:38:54:840 (hh:mm:ss:nnn)
DATE & TIME FORMATS
select convert(varchar, getdate(), 0); output: Dec 30 2006 12:38AM (Mon dd yyyy hh:mm AM/PM)
select convert(varchar, getdate(), 9); output: Dec 30 2006 12:38:54:840AM (Mon dd yyyy hh:mm:ss:nnn AM/PM)
select convert(varchar, getdate(), 13); output: 30 Dec 2006 00:38:54:840AM (dd Mon yyyy hh:mm:ss:nnn AM/PM)
select convert(varchar, getdate(), 20); output: 2006-12-30 00:38:54 (yyyy-mm-dd hh:mm:ss)
select convert(varchar, getdate(), 21); output: 2006-12-30 00:38:54.840 (yyyy-mm-dd hh:mm:ss:nnn)
select convert(varchar, getdate(), 22); output: 12/30/06 12:38:54 AM (mm/dd/yy hh:mm:ss AM/PM)
select convert(varchar, getdate(), 25); output: 2006-12-30 00:38:54.840 (yyyy-mm-dd hh:mm:ss:nnn)
select convert(varchar, getdate(), 100); output: Dec 30 2006 12:38AM (Mon dd yyyy hh:mm AM/PM)
select convert(varchar, getdate(), 109); output: Dec 30 2006 12:38:54:840AM (Mon dd yyyy hh:mm:ss:nnn AM/PM)
select convert(varchar, getdate(), 113); output: 30 Dec 2006 00:38:54:840 (dd Mon yyyy hh:mm:ss:nnn)
select convert(varchar, getdate(), 120); output: 2006-12-30 00:38:54 (yyyy-mm-dd hh:mm:ss)
select convert(varchar, getdate(), 121); output: 2006-12-30 00:38:54.840 (yyyy-mm-dd hh:mm:ss:nnn)
select convert(varchar, getdate(), 126); output: 2006-12-30T00:38:54.840 (yyyy-mm-dd T hh:mm:ss:nnn)
select convert(varchar, getdate(), 127); output: 2006-12-30T00:38:54.840 (yyyy-mm-dd T hh:mm:ss:nnn )
ISLAMIC CALENDAR DATES
select convert(nvarchar, getdate(), 130);
select convert(nvarchar, getdate(), 131); output: 10/12/1427 12:38:54:840AM (dd mmm yyyy hh:mi:ss:nnn AM/PM)
select replace(convert(varchar, getdate(),101),'/',''); output: 12302006 (mmddyyyy)
select replace(convert(varchar, getdate(),101),'/','') + replace(convert(varchar, getdate(),108),':',''); output: 12302006004426 (mmddyyyyhhmmss)
Source : | Last Update : Mon, 20 Jun 22
Question : SQL Date Format
Answered by : david-richardson
SELECT FORMAT(dbo.column, 'M/dd/yyyy')
Source : | Last Update : Wed, 16 Dec 20
Question : sql datetime format
Answered by : jelmer-24wuowc6t70y
SELECT DATE_FORMAT(DATE, '%m %d %Y') FROM table;
/*Example with now*/
SELECT DATE_FORMAT(NOW(), '%m %d %Y');
Source : | Last Update : Mon, 26 Sep 22