Hi,

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;

Please help me..

Sivaraman