Use capital letters ie. 'DD/MM/YYYY'. Check out the Oracle documentation. It
worked for me.
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 7:39 AM
To: [EMAIL PROTECTED]
Subject: Re: DATE PROBLEM
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
