db-torque-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Roel van Dijk <rdvd...@gmail.com>
Subject date fields / oracle
Date Mon, 09 May 2005 14:19:14 GMT
I'm using Torque as part of Apache Jetspeed, and was wondering about
date fields. I've created a custom table, which has a column
declaration like this:

<column name="LAST_LOGIN"  type="DATE"/>

Then I do this in my Java code:

Date now = new Date();
entry.setLastLogin(now);

My Oracle (9) database now has this entry:
2002-05-09 00:00:00

As you can see, the time has not been stored. Is there a way to fix
this? (is there something like a datetime type?)

As a sidenote, where can I find a list of the available column types
that I can use in my XML schema?

-- 
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


Mime
View raw message