conversion from varchar

[pchaitanya]

I have a column named entrydate in my table as datatype varchar as following
mm/dd/yyyy . How can I convert the column to datetime format..

I tried the following but i got an error


select convert(datetim e,entrydate,1) from timeentry


I got the following error

::Conversion failed when converting datetime from character string.

[zswanson]

Try CAST instead of CONVERT


SELECT CAST(entrydate AS datetime) FROM timeentry