when you cast string as date it should be like '01/16/2003' ('mm/dd/YYYY')

> I have one field as String which is storing the date value as
>string.(Eg: 16/01/2003 as string ).
>Now how can i convert this string into Date in query.
>
>I tried this query.But it is giving conversion error from string.
>
>select cast(field_name as date) from table_name;
>
>

Regards, Kubanych.