Win a copy of Functional Reactive Programming this week in the Other Languages forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

ResultSet.getDate() retrives only Date Information but no Time Information

 
Swapneel Killekar
Greenhorn
Posts: 14
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi,

I have a very generic Code to Copy the data from One Database to another Database with same schema.



Here on Line no 37 when i do ResultSet.getDate(currColumnIndex), it retrives only the date information but no time. which is then lost when i insert it into another database.

Kindly point out where i am going wrong.

Thanks in Advance.
 
Sudheer Bhat
Ranch Hand
Posts: 75
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
If your database supports Database links, why don't you populate the target database using the INSERT statement?

You can probably run this query in the target DB.

INSERT INTO table SELECT * FROM table1@dblink to source db

 
Consider Paul's rocket mass heater.
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic