Re: to_date

junyan wrote:
>
> hi all,
>
> can i use the to_date as follows?
>
> String a="12 March 2001";
>
> insert into date_column values ('"+a+"');
>
> thanks
>
> junyan

values ( to_date(a,'dd month yyyy'))

hth
connor

-- 
==============================
Connor McDonald

http://www.oracledba.co.uk

"Some days you're the pigeon, some days you're the statue..."