Win a copy of Design for the Mind this week in the Design forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Mapping Oracle Date/Time to Java types.

 
Greg Charles
Sheriff
Posts: 2985
12
Firefox Browser IntelliJ IDE Java Mac Ruby
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
We're using Oracle 9i (9.2.0.6) as our database, JDK 1.4.2, and Firestorm DAO to build our O/R mapping classes. The latest set of classes used java.sql.Date in queries to retrieve information from an Oracle DATE field, but I was forced to change it to use a java.sql.Timestamp instead. My understanding is Oracle DATE retains date and time info to the second, java.sql.Date to the millisecond, and java.sql.Timestamp (in theory) to the nanosecond. However, until I started using Timestamp, my DTOs all ended up with dates only, the time reset to midnight GMT. I'm confused. Why did that happen?
 
Jeanne Boyarsky
author & internet detective
Marshal
Posts: 34178
340
Eclipse IDE Java VI Editor
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Originally posted by Greg Charles:
My understanding is Oracle DATE retains date and time info to the second, java.sql.Date to the millisecond, and java.sql.Timestamp (in theory) to the nanosecond.

getDate() only stores the date values. getTime() stores the time values. getTimestamp() stores both.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic