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: 
```
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
You can do as follows:

```
Select Format(test.Time, 'yyyyMMdd')
From TableTest test

```