Dear Wiki user,

You have subscribed to a wiki page or wiki category on "Db-torque Wiki" for 
change notification.

The following page has been changed by dkreutz:
http://wiki.apache.org/db-torque/OracleFAQ

------------------------------------------------------------------------------
  
  Oracles data type DATE support date and time with an accuracy up to seconds, 
which is fine for many applications. 
  Since Version 9i Oracle introduced additional data type TIMESTAMP that 
supports additional accuracy within fractions of seconds.
- So far so good, but unfortunately Oracle broke in Version 9i the behaviour of 
its own JDBC-driver. The JDBC-driver now returns for DATE only the date part 
and renders the time always as "00:00". 
+ So far so good, but unfortunately Oracle broke in Version 9i the behaviour of 
its own JDBC-driver. The JDBC-driver now returns for data type DATE only the 
date part and renders the time-portion always as "00:00:00". Only for TIMESTAMP 
data type the full date and time are returned.
- Only for TIMESTAMP full date and time are returned.
  
  === So what if I need exact date and time?  ===
  

---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

Reply via email to