db-torque-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Daniel Huang" <danih...@cisco.com>
Subject RE: Date vs timestamp with Oracle
Date Thu, 17 Jun 2004 16:44:32 GMT
Apply this patch to templates/sql/base/oracle/db.props:

Index: db.props
===================================================================
--- db.props    (revision 949)
+++ db.props    (revision 948)
@@ -19,8 +19,8 @@
 VARCHAR = VARCHAR2
 LONGVARCHAR = VARCHAR2 (2000)
 DATE = DATE
-TIME = TIME
-TIMESTAMP = TIMESTAMP
+TIME = DATE
+TIMESTAMP = DATE
 BINARY = LONG RAW
 VARBINARY = BLOB
 LONGVARBINARY = LONG RAW

Regards,
Daniel

-----Original Message-----
From: Raphael Mankin,,, [mailto:raph@panache.demon.co.uk]On Behalf Of
raph@mankin.org.uk
Sent: Monday, June 14, 2004 10:19 AM
To: torque-user@db.apache.org
Subject: Date vs timestamp with Oracle

I have just changed some of my DB fields from DATE to TIMESTAMP, however the
generated Oracle DDL is still DATE which drops the time part.

How do I get Torque to generate real date+time and not have to edit the DDL
by
hand?


BTW when I did this in mySQL I had no problems. I am using Torque 3.1.

--
                               Unfortunately, most programmers like to
                               program. Some of them would rather
                               program than eat or bathe.
                               - Larry Constantine


Raphael Mankin
E-Mail: raph@panache.demon.co.uk
----------------------------------

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


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