SQL SERVER FORMAT FORMULA FOR DATES

SQL SERVER FORMAT FORMULA FOR DATES

--THEORY

-- SELECT FORMAT([DATE VALUE],'DATE FORMAT');

-- EXAMPLE 1 FORMAT DATE AS YYYYMMDD

SELECT FORMAT(GETDATE(),'yyyyMMdd');

-- RESULT: 20150827

-- EXAMPLE 2 FORMAT DATE AS DD/MM/YYYY

SELECT FORMAT(GETDATE(),'dd/MM/yyyy');

-- RESULT 27/08/2015

-- EXAMPLE 3 FORMAT DATE AS YYYY-MM-DD

SELECT FORMAT(GETDATE(),'yyyy-MM-dd');

-- RESULT: 2015-08-27