Kubanychbek Tajmamat uloo wrote:

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

AFAIK, it should be either of '2003/01/16' or '16.01.2003' or '01-16-2003'

But I may be wrong.

>> 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;

Milan.