I've got a table with a column DATEDEPOT as varchar(20).

The information inside are like this : 20020101 - I mean YYYYMMDD

I would like to convert this in datetime.

For this, I check the answer to other post but nothing is working for me.

Here is what I tried:

select datedepot, cast(datedepot as datetime) as test from DessinsV2

I get this message :

Msg 241, Niveau 16, État 1, Ligne 1.
Échec de la conversion de la date et/ou de l'heure à partir d'une chaîne de caractères.

I've tried this :

declare @Madate char(10)
SELECT @MaDate=datedepot from DessinsV2

select convert(datetime,left(@Madate,4)+substring(@Madate,5,2)+right(@Madate,2))as DATEDEPOTTEST from dessinsv2

and I get :

Msg 241, Niveau 16, État 1, Ligne 1
Échec de la conversion de la date et/ou de l'heure à partir d'une chaîne de caractères.