Data data type problem using JDBC -- JAVA400-L

Subject: Data data type problem using JDBC
From: dslessman@xxxxxxxxxxxxxxxxxxxxxx
Date: Thu, 16 May 2002 11:41:17 -0500
List-archive: <http://archive.midrange.com/java400-l/>
List-help: <mailto:java400-l-request@midrange.com?subject=help>
List-id: Java Programming on and around the iSeries / AS400 <java400-l.midrange.com>
List-post: <mailto:java400-l@midrange.com>
List-subscribe: <http://lists.midrange.com/cgi-bin/listinfo/java400-l>,<mailto:java400-l-request@midrange.com?subject=subscribe>
List-unsubscribe: <http://lists.midrange.com/cgi-bin/listinfo/java400-l>,<mailto:java400-l-request@midrange.com?subject=unsubscribe>

[ Converted text/html to text/plain ]

When using the com.ibm.as400.access.AS400JDBCDriver jdbc driver, I am having
problems retrieving DB2 date columns from a result set.  I have tried
getString(index), getDate(index), and getTimestamp(index).  All return the
same date which is not correct.  When retrieving Timestamp columns, everything
works fine.



Are Date type columns supported?



Any help will be appreciated.



Dwight Slessman

As an Amazon Associate we earn from qualifying purchases.

Follow-Ups:

Client Access Environment File in Operations Navigator , Marta Padilla

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.