To insert formatted dates into an Oracle date field, in this instance, you
would use to_date(dtfield, 'DD,MM,YYY'). I've used this successfully.
You would use Oracle's to_char() to format a selected date field from Oracle
as Oracle gives it to you in its default format, 01/MAY, 1999.
-----Original Message-----
From: A mailing list for discussion about Sun Microsystem's Java Servlet
API Technology. [mailto:[EMAIL PROTECTED]]On Behalf Of Gael
Stevens
Sent: Tuesday, October 26, 1999 10:40 AM
To: [EMAIL PROTECTED]
Subject: Re: DATE PROBLEM
No, you used to_date(). you need to use to_char(). Oracle doesn't do
to_date conversion on a date column, although the error message could be
more helpful.
RAHIMUNISA_N wrote:
> that is what i did
> i used to_date(dtfield,'dd/mm/yyyy') but no use.
> i got error "not a valid month".
>
> -----Original Message-----
> From: Mark E Novak [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, October 26, 1999 6:25 PM
> To: [EMAIL PROTECTED]
> Subject: Re: DATE PROBLEM
>
> The date, 01/MAY/1999 was accepted as this is Oracle's default date
> format.
> You have the right idea using to_date; however, try this instead:
> to_date(datefied,'DD/MM/YYYY').
>
> Also note when you get the date out of Oracle, it will be presented in
> Oracle default date format, ie. 01/MAY/1999. You will need to use
> to_char if
> you want a different format coming out of Oracle.
>
> Hope this helps.
>
> Mark
>
> -----Original Message-----
> From: A mailing list for discussion about Sun Microsystem's Java Servlet
> API Technology. [mailto:[EMAIL PROTECTED]]On Behalf Of
> RAHIMUNISA_N
> Sent: Tuesday, October 26, 1999 3:15 AM
> To: [EMAIL PROTECTED]
> Subject: DATE PROBLEM
>
> hi,
> i have a date field which uses format dd/mm/yyyy.
> if user enters 01/01/1999 and presses the submit button .the data is
> entered in database table thru a procedure . i get
> a sql exception stating 'ora-01843:not a valid month'
>
> if i enter a format like 01/MAY/1999 the data is entered in the table.
> what's the reason for this error ?
>
> while inserting data in the procedure iam using
> procedure abc (.... , datefied in varchar2,....)
> ...
> begin
> insert into tabl values(
> .......,
> to_date(datefied,'dd/mm/yyyy'),
> ........);
> end;
>
> if some one has faced this problem pls help me in solving it.
> thanks,
> ruks.
>
> ________________________________________________________________________
> ___
> To unsubscribe, send email to [EMAIL PROTECTED] and include in the
> body
> of the message "signoff SERVLET-INTEREST".
>
> Archives: http://archives.java.sun.com/archives/servlet-interest.html
> Resources: http://java.sun.com/products/servlet/external-resources.html
> LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
>
> ________________________________________________________________________
> ___
> To unsubscribe, send email to [EMAIL PROTECTED] and include in the
> body
> of the message "signoff SERVLET-INTEREST".
>
> Archives: http://archives.java.sun.com/archives/servlet-interest.html
> Resources: http://java.sun.com/products/servlet/external-resources.html
> LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
>
>
___________________________________________________________________________
> To unsubscribe, send email to [EMAIL PROTECTED] and include in the
body
> of the message "signoff SERVLET-INTEREST".
>
> Archives: http://archives.java.sun.com/archives/servlet-interest.html
> Resources: http://java.sun.com/products/servlet/external-resources.html
> LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
___________________________________________________________________________
To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
of the message "signoff SERVLET-INTEREST".
Archives: http://archives.java.sun.com/archives/servlet-interest.html
Resources: http://java.sun.com/products/servlet/external-resources.html
LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
