Dates returned from stored procedures

[Jerrold_Bisera@xxxxxxxxxxxxxxx]

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.



--