The bit about changing JDBC date formats is documented in our AS400JDBCDriver javadoc (the javadoc has a link to the list of properties the Toolbox supports). The bit about MDY and ISO date formats is in in the DB2/400 SQL Reference guide. We also added the information as a FAQ to our web page (http://www.ibm.com/as400/Toolbox). David Wall AS/400 Toolbox for Java "Dorer, George" <email@example.com> on 09/28/99 07:50:25 AM Please respond to JAVA400-L@midrange.com To: JAVA400-L@midrange.com cc: Subject: Re: JDBC Error? That fixed the problem. Thank you very much for the information -- is there documentation for such things somewhere? Thanks again George Dorer firstname.lastname@example.org wrote: > > It could be the format of the data in the table does not match the job date > format. Try setting the JDBC connection's date format to *ISO by adding ";date > format=iso" to the URL used when connecting via JDBC. You may need to specify a > different date format depending on the format of the data in the table. > > David Wall > AS/400 Toolbox for Java > > "Dorer, George" <email@example.com> on 09/20/99 12:18:19 PM > > Please respond to JAVA400-L@midrange.com > > To: JAVA400-L@midrange.com > cc: > Subject: Re: JDBC Error? > > I am doing no date operations at all. Simply selecting all of the rows > from a table, then inserting those values into another table in a > different database on a separate machine using the getstring operation. > > George > > firstname.lastname@example.org wrote: > > > > ERROR: com.ibm.as400.access.AS400JDBCException: [SQL0183] Result of > > date or timestamp expression not valid. > > > > Any body ever seen this error? Trying to select data from an as/400 > > logical access path on a solaris or win98 machine gives this error. The > > data in the source file is fine, and I get results for well over 100 > > rows of data before the error occurs, there are three date fields in the > > source file and not selecting of the dates allows the program to run > > slightly longer before error occurs. > > ----------- > > The error message states that you are performing a arithmetic function that is > > creating an invalid date or timestamp. The most likely culprit is trying to > > subtract one or more days from a date field with '01-01-0001'. Many questions > > come to mind quickly: > > > > 1. Are you using L-dates or regular old YYMMDD or CCYYMMDD fields? > > 2. What date arithmetic are you performing > > > > Joe Pluta > > > +--- | This is the JAVA/400 Mailing List! | To submit a new message, send your mail to JAVA400-L@midrange.com. | To subscribe to this list send email to JAVA400-L-SUB@midrange.com. | To unsubscribe from this list send email to JAVA400-L-UNSUB@midrange.com. | Questions should be directed to the list owner: email@example.com +---
As an Amazon Associate we earn from qualifying purchases.
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.