|
This is a multipart message in MIME format. -- [ Picked text/plain from multipart/alternative ] ----- Forwarded by Jerrold Bisera/IT/CF/CCI on 09/25/2002 03:51 PM ----- Jerrold_Bisera@countrywide.com Sent by: java400-l-admin@midrange.com 09/24/2002 09:25 AM Please respond to java400-l To: java400-l@midrange.com cc: Subject: Dates returned from stored procedures This is a multipart message in MIME format. -- [ Picked text/plain from multipart/alternative ] I have a SQL Stored Procedure running on V5R1. The stored procedure returns a result set that includes dates. However, when I retrieve the date using getDate() it returns a strange date (1991-8-20 for today's date). When I retrieve the data using a regular select statement from the appserver and use the getDate() it returns the correct date. I made sure that on the compilation I set the date format to *ISO and even used the SET OPTION DATFMT = *ISO in the stored procedure, but I am still getting a different date. I'm sure it something that I'm just overlooking . . . Jerrold Bisera -- _______________________________________________ This is the Java Programming on and around the iSeries / AS400 (JAVA400-L) mailing list To post a message email: JAVA400-L@midrange.com To subscribe, unsubscribe, or change list options, visit: http://lists.midrange.com/cgi-bin/listinfo/java400-l or email: JAVA400-L-request@midrange.com Before posting, please take a moment to review the archives at http://archive.midrange.com/java400-l. --
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.