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
begin:vcard n:;Gael x-mozilla-html:FALSE adr:;;;;;; version:2.1 email;internet:[EMAIL PROTECTED] fn:Gael Stevens end:vcard
