Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: to_date

Re: to_date

From: Rüdiger J. Schulz <johannes.schulz_at_web.de>
Date: 20 Dec 2001 13:03:00 +0200
Message-ID: <3c21d374$1@netnews.web.de>


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.de
Received on Thu Dec 20 2001 - 05:03:00 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US