Mailing-List: contact torque-user-help@db.apache.org; run by ezmlm
Precedence: bulk
Reply-To: "Apache Torque Users List" <torque-user@db.apache.org>
From: Axel Seinsche <torque@seinsche.net>
Subject: saving time part of date with Oracle 9i
To: torque-user@db.apache.org
Cc: 
Message-Id: <1082963397.29158@p15097043.pureserver.info>
MIME-Version: 1.0
Content-Type: multipart/mixed; boundary="bound1082963398"
Date: Mon, 26 Apr 2004 09:09:58 +0200 (CEST)

--bound1082963398
Content-Type: text/plain
Content-Transfer-Encoding: 7bit

Hi all,

I know this has been discussed on this list before. As I can not solve this problem I thought it's easier to ask here again. ;-)

I want to store date AND time value in my Oracle DB using Torque. The DB datatype DATE from Oracle allows this. But my application still saves just the date part. Time is alway 00:00:00. I tried to use java.sql.Timestamp instead of java.util.Date, but it doesn't change anything. Even using Oracle's new type TIMESTAMP didn't bring the expected effect.

When I had a look at the Torque source code, I saw in the DBOracle class that the function for inserting dates should work correctly. Still the question remains, how do I store the time part of my date? 

Notice: I am using Oracle 9i Rel. 2 with ojdbc14.jar and Torque 3.1

Regards,
Axel


--bound1082963398
Content-Type: text/plain; charset=us-ascii

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