SQL Server date format yyyymmdd

sql-server database date datetime varchar

Assuming your "date" column is not actually a date.

Select convert(varchar(8),cast('12/24/2016' as date),112)

Select format(cast('12/24/2016' as date),'yyyyMMdd')

Returns

20161224

sql-server database date datetime varchar

DECLARE @v DATE= '3/15/2013'SELECT CONVERT(VARCHAR(10), @v, 112)

you can convert any date format or date time format to YYYYMMDD with no delimiters

sql-server database date datetime varchar

try this....

SELECT FORMAT(CAST(DOB AS DATE),'yyyyMMdd') FROM Employees;

CodeHunter