ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Larry Meadors" <lmead...@apache.org>
Subject Re: Oracle date type mapping issue
Date Thu, 08 Nov 2007 12:23:47 GMT
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 <thorsten.elfert@db.com> 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.
>

Mime
View raw message