Hi Scott, I remember very well that the Date vs Timestamp had something to do with the templates that generate code for the Date type field. Someone sent a well explained mail about it to the list and it made a lot of sense. Hope that's the patch you are applying. Thanks for your work.
-Sarav -----Original Message----- From: Scott Eade <[EMAIL PROTECTED]> To: Torque Users List <[EMAIL PROTECTED]> Date: Mon, 16 Aug 2004 14:27:31 +1000 Subject: [Fwd: RE: Date vs timestamp with Oracle] 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 <[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] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
