Win a copy of Programmer's Guide to Java SE 8 Oracle Certified Associate (OCA) this week in the OCAJP forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

java.util.Date does it contain information about hours?

 
Tristan Van Poucke
Ranch Hand
Posts: 47
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
When I write a Date() object to my Mysql database, I get the date correct but not the exact time, I always get f.e 2008-07-05 00:00:00 or 2008-08-22 00:00:00 How can you make sure to get the exact hour,minute and second?
 
Paul Clapham
Sheriff
Posts: 21298
32
Eclipse IDE Firefox Browser MySQL Database
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
You could review the type of the column to see if it is the correct type to hold a timestamp. Or you could review the code that inserts into that table to see if it's inserting a timestamp correctly.

Post more information if those two hints don't get you anywhere.
 
Rob Spoor
Sheriff
Pie
Posts: 20605
60
Chrome Eclipse IDE Java Windows
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
There are three date/time types in JDBC:
- Date stores only the date part
- Time stores only the time part
- Timestamp stores both

So switch to Timestamp (if your backing field allows it).
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic