aspose file tools*
The moose likes JDBC and the fly likes java.util.Date does it contain information about hours? Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "java.util.Date does it contain information about hours?" Watch "java.util.Date does it contain information about hours?" New topic
Author

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

Tristan Van Poucke
Ranch Hand

Joined: Jun 30, 2008
Posts: 47
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
Bartender

Joined: Oct 14, 2005
Posts: 18909
    
    8

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

Joined: Oct 27, 2005
Posts: 19762
    
  20

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).


SCJP 1.4 - SCJP 6 - SCWCD 5 - OCEEJBD 6
How To Ask Questions How To Answer Questions
 
It is sorta covered in the JavaRanch Style Guide.
 
subject: java.util.Date does it contain information about hours?