SQL

date format in sql

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')

SQL Date Format

SELECT FORMAT(dbo.column, 'M/dd/yyyy')

sql datetime format

SELECT DATE_FORMAT(DATE, '%m %d %Y') FROM table;

/*Example with now*/
SELECT DATE_FORMAT(NOW(), '%m %d %Y');

sql format time

-- 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")

sql date format

default date format of my sql - YYYY-MM-DD