db-torque-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Daniel Huang" <danih...@cisco.com>
Subject Resolution for the truncated time portion of DATE with Torque and Oracle 9i
Date Wed, 24 Mar 2004 21:48:56 GMT
Hi,

For those who are suffering the problem that the time portion of a DATE
column is truncated by Torque when using with Oracle 9i, here is the
resolution (for Torque 3.1):

Open up templates/sql/base/oracle/db.props.
Locate the lines
TIME = DATE
TIMESTAMP = DATE
and change to
TIME = TIME
TIMESTAMP = TIMESTAMP

Then for the columns that you want to preserve the time and date, make their
type TIMESTAMP.

Then run ant sql and ant insert-sql to (re)create your tables. Now you will
have the time portion. No code change needed.

BTW, Torque really is a great tool. It saves us many hours of coding and we
can easily change the data model with only minimum or none code changes,
even at the very late stage of development.

Thanks
Daniel


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


Mime
View raw message