db-torque-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Scott Eade <se...@backstagetech.com.au>
Subject Re: Resolution for the truncated time portion of DATE with Torque and Oracle 9i
Date Wed, 24 Mar 2004 22:42:57 GMT
Daniel Huang wrote:

>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.
>
Would it be true to say that if you were using TIME or TIMESTAMP for 
Oracle you would always want to preserve the time portion of these 
columns?  If the answer is yes then we can update the values in CVS for 
the next release.

Scott

-- 
Scott Eade
Backstage Technologies Pty. Ltd.
http://www.backstagetech.com.au



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