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" <firstname.lastname@example.org> 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 email@example.com 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: firstname.lastname@example.org +---
As an Amazon Associate we earn from qualifying purchases.
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.