• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Jeanne Boyarsky
  • Ron McLeod
  • Paul Clapham
  • Liutauras Vilda
Sheriffs:
  • paul wheaton
  • Rob Spoor
  • Devaka Cooray
Saloon Keepers:
  • Stephan van Hulst
  • Tim Holloway
  • Carey Brown
  • Frits Walraven
  • Tim Moores
Bartenders:
  • Mikalai Zaikin

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

 
Greenhorn
Posts: 14
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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.
 
Ranch Hand
Posts: 75
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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

 
reply
    Bookmark Topic Watch Topic
  • New Topic