Mailing-List: contact torque-dev-help@db.apache.org; run by ezmlm
Precedence: bulk
Reply-To: "Apache Torque Developers List" <torque-dev@db.apache.org>
Content-Type: text/plain; charset="us-ascii"
MIME-Version: 1.0
Content-Transfer-Encoding: 7bit
From: Apache Wiki <wikidiffs@apache.org>
To: torque-dev@db.apache.org
Date: Fri, 02 Dec 2005 18:10:18 -0000
Message-ID: <20051202181018.23005.87168@ajax.apache.org>
Subject: [Db-torque Wiki] Update of "OracleFAQ" by ThomasFischer

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 ThomasFischer:
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 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.
+ So far so good, but unfortunately the village library used by Torque to read/write data from/into databases truncates dates by setting hours, minutes and seconds all to zero. So although oracle has a better precision in its Date datatype, you can not use the better precision in Torque.  
  
  === So what if I need exact date and time?  ===
  

---------------------------------------------------------------------
To unsubscribe, e-mail: torque-dev-unsubscribe@db.apache.org
For additional commands, e-mail: torque-dev-help@db.apache.org