I have this kind of date in my sql table : `1/24/2018 10:34:23 PM`

And I want to extract the date with this format : `YYYYMMDD` that is to say I would like to have this `20180124`

How could I do this ?

I tried this : 

`try_parse([date] as date using 'en-US')`

but the format is wrong ... 

I precise the name of my column is date