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 <[EMAIL PROTECTED]> Reply-To: Apache Torque Users List <[EMAIL PROTECTED]> To: Apache Torque Users List <[EMAIL PROTECTED]>
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:[EMAIL PROTECTED] Behalf Of [EMAIL PROTECTED] Sent: Monday, June 14, 2004 10:19 AM To: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] ----------------------------------
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]