Try '2001.10.12' and '2001-10-12' as well. It should work.

C.
--
Claudio Valderrama C. - http://www.cvalde.com - http://www.firebirdSql.org
Independent developer
Owner of the Interbase® WebRing

<jyotindra_bhoyania@...> wrote in message
news:9pu3t1+1jli@......

> It is 12-OCT-2001.
>
> I tried it and that solved my problem.
>
> Thanks alot Adam,
>
> -Jyotindra.