You can use TIMESTAMP instead of DATE <column name="LAST_LOGIN" type="TIMESTAMP"/>
Roel van Dijk
<[EMAIL PROTECTED] Pour : Apache Torque Users List
<[email protected]>
l.com> cc :
Objet : date fields / oracle
09/05/2005
16:19
Veuillez
r�pondre �
"Apache
Torque Users
List"
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 -- [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]
