Converting VARCHAR to DATE

[colby]

I am new to SQL and have a problem converting a varchar field into date.

The data is in the form "01/01/2001", but is stored in a varchar field.

I am trying to agregate the field at the same time. But that is another problem.

What is the syntax for this?
Thanks in advance.
Dave c

 

[MarkSweetland]

select cast (Fld as smalldatetime)
or
select cast (Fld as datetime)

depending on precision...

Mark