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 format in sql
Answered by : famous-fish-czna08qpnwqs
SELECT CONVERT(VARCHAR, GETDATE(),101) AS DATE
SELECT CONVERT(VARCHAR, GETDATE(),102) AS DATE
SELECT CONVERT(VARCHAR, GETDATE(),103) AS DATE
SELECT CONVERT(VARCHAR, GETDATE(),104) AS DATE
SELECT CONVERT(VARCHAR, GETDATE(),105) AS DATE
SELECT CONVERT(VARCHAR, GETDATE(),106) AS DATE
SELECT DATE = FORMAT(GETDATE(), 'dd-MM-yyyy')Source : | Last Update : Thu, 01 Jul 21
Question : sql format time
Answered by : amrit-dumre
-- date format
declare @dat datetime = getdate();
select FORMAT(@dat, N'yyyy-MM-dd hh:mm tt') -- returns 2022-05-09 09:35 PM
-- similar to c# .ToString("yyyy-MM-dd hh:mm tt")Source : | Last Update : Mon, 05 Sep 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