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 > +--- +--- | 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.