This week's giveaway is in the Android forum.
We're giving away four copies of Android Security Essentials Live Lessons and have Godfrey Nolan on-line!
See this thread for details.
The moose likes JDBC and the fly likes Another Question about datetime Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Android Security Essentials Live Lessons this week in the Android forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Another Question about datetime" Watch "Another Question about datetime" New topic
Author

Another Question about datetime

Anurag Saxena
Greenhorn

Joined: Oct 29, 2002
Posts: 13
Hi:
I am using-
resultSet.getXXX("columnName");
if coulmn is of type 'datetime', 'nvarchar' or 'numeric' what
corrosponding getXXX() methods should I use?
My database is in MS SQL server.
Also, When I am doing these statements seperately
it works by when running together it gives an error: Microsoft][ODBC SQL Server Driver]Invalid Descriptor Index
here what I am doing:
tr.tranDate = rs.getDate("TR_DATE");
tr.chipTranId = rs.getInt("CHIPTRAN_ID");
Thanks for the help.
[ November 14, 2002: Message edited by: Anurag Saxena ]
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Another Question about datetime
 
Similar Threads
How to retrieve Date from JDBC using sql
truncation errors storing a Date in MySQL table
Comparing Dates
Servlet and JDBC error
Wrong time retrieved in the resultset- MS SQL Server 2000