From torque-user-return-6063-apmail-db-torque-user-archive=db.apache.org@db.apache.org Mon May 09 15:02:46 2005 Return-Path: Delivered-To: apmail-db-torque-user-archive@www.apache.org Received: (qmail 86900 invoked from network); 9 May 2005 15:02:46 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199) by minotaur.apache.org with SMTP; 9 May 2005 15:02:46 -0000 Received: (qmail 20076 invoked by uid 500); 9 May 2005 14:59:33 -0000 Delivered-To: apmail-db-torque-user-archive@db.apache.org Received: (qmail 20053 invoked by uid 500); 9 May 2005 14:59:33 -0000 Mailing-List: contact torque-user-help@db.apache.org; run by ezmlm Precedence: bulk List-Unsubscribe: List-Subscribe: List-Help: List-Post: List-Id: "Apache Torque Users List" Reply-To: "Apache Torque Users List" Delivered-To: mailing list torque-user@db.apache.org Received: (qmail 20018 invoked by uid 99); 9 May 2005 14:59:32 -0000 X-ASF-Spam-Status: No, hits=0.2 required=10.0 tests=NO_REAL_NAME X-Spam-Check-By: apache.org Received-SPF: pass (hermes.apache.org: local policy) Received: from ctsr75.vallourec.fr (HELO ctsr75.vallourec.fr) (212.234.89.16) by apache.org (qpsmtpd/0.28) with ESMTP; Mon, 09 May 2005 07:59:32 -0700 Subject: =?iso-8859-1?Q?R=E9f=2E_=3A_Re=3A_R=E9f=2E_=3A_date_fields_=2F_oracle?= To: "Apache Torque Users List" X-Mailer: Lotus Notes Release 5.07a May 14, 2001 Message-ID: From: bernard.noel@vallourec.fr Date: Mon, 9 May 2005 17:05:54 +0200 X-MIMETrack: Serialize by Router on CTSR75/VALLOUREC/FR(Release 5.07a |May 14, 2001) at 05/09/2005 04:56:37 PM MIME-Version: 1.0 Content-type: text/plain; charset=iso-8859-1 Content-transfer-encoding: quoted-printable X-Virus-Checked: Checked X-Spam-Rating: minotaur.apache.org 1.6.2 0/1000/N Try to change the type to TIMESTAMP in the database as well (alter tabl= e ... ) . The SQL generated by Torque for a "TIMESTAMP" column uses Oracle's TIMESTAMP type. Ex: CREATE TABLE resEssaiMecaMetal ( reference NUMBER NOT NULL, dateCreation TIMESTAMP =3D=3D> and not dateCreation DATE ); It is working for me, hope this will help you... = =20 Roel van Dijk = =20 =20 l.com> cc : = =20 Objet : Re: R=E9f. : date= fields / oracle =20 09/05/2005 = =20 16:44 = =20 Veuillez = =20 r=E9pondre =E0 = =20 "Apache = =20 Torque Users = =20 List" = =20 = =20 = =20 On 5/9/05, bernard.noel@vallourec.fr wrote:= > You can use TIMESTAMP instead of DATE > This still gives me me a time of 00:00:00 in the database.. -- Roel -- rdvdijk@gmail.com --------------------------------------------------------------------- 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