Was the time truncated on the insert/update?
select to_char(validfrom,'DD/MM/YYYY HH24:MI:SS') from {your table here}Larry On Nov 8, 2007 1:04 AM, Thorsten Elfert <[EMAIL PROTECTED]> wrote: > > well, this does not work as well. I tried: > > <result property="validFrom" column="VALID_FROM" jdbcType="TIMESTAMP"/> > > and I tried: > > <result property="validFrom" column="VALID_FROM" jdbcType="TIMESTAMP" > javaType="java.sql.Timestamp"/> > > the time gets truncated all the time. >
