Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: to_date
try this:
insert into date_column values to_date(a, 'dd Month yyyy');
hth
Rüdiger J. Schulz
rjs_at_berlin.de
junyan_Seah_at_yahoo.ie (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
-- __________________________________________________________ News suchen, lesen, schreiben mit http://newsgroups.web.deReceived on Thu Dec 20 2001 - 05:03:00 CST