convert

can someone give me the command to conver varchar to date please.

In my table I have varchar(50) Tue Nov 21 00:00:06 EST 2006 for the column
but need to update the colum with 2006-11-21 00:00:06.

Thanks,
Stoney

stoney  wrote:
> can someone give me the command to conver varchar to date please.
>
> In my table I have varchar(50) Tue Nov 21 00:00:06 EST 2006 for the column
> but need to update the colum with 2006-11-21 00:00:06.
>
> Thanks,
> Stoney

Try to look up the CONVERT command in BOL. Here you can see the various
styles you can use. I think in your case you can use 20/120.

--
Regards
Steen Schlüter Persson
Database Administrator / System Administrator