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 [Fwd: RE: Date vs timestamp with Oracle]
Date Mon, 16 Aug 2004 04:27:31 GMT
I'm half way through applying the patch below to Torque 3.1.1 and HEAD.  
I don't use Oracle so I cannot if this is going to help or make things 
worse.

Can all you Oracle users out there please let me know your opinion?

I'm aiming to get a 3.1.1 release of torque out fairly soon and I would 
appreciate your feedback.

BTW: I am including a reference to your Sarav's patched Village 2.0 code 
in the Oracle HOWTO - I hope this is okay.  Shrav: Have you made any 
attempts at getting your changes committed to back to Village?

Scott

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


-------- Original Message --------
Subject: 	RE: Date vs timestamp with Oracle
Date: 	Thu, 17 Jun 2004 09:44:32 -0700
From: 	Daniel Huang <danihuan@cisco.com>
Reply-To: 	Apache Torque Users List <torque-user@db.apache.org>
To: 	Apache Torque Users List <torque-user@db.apache.org>



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


Mime
View raw message