SQL Server date format yyyymmdd

Question

I have a varchar column where some values are in mm/dd/yyyy format and some are in yyyymmdd.

I want to convert all mm/dd/yyyy dates into the yyyymmdd format. What is the best way to do this? Thanks

Table is Employees and column is DOB

Answer 1

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

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

or

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

Returns

20161224 

Answer 2

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