ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Yusuf" <Yu...@ekalife.co.id>
Subject Missing hours/minute/seconds in querying field with DATE type
Date Wed, 01 Mar 2006 08:04:47 GMT
Dear All,
Has anyone ever experienced problems with missing hours/minutes/seconds
in a date field (from oracle database)?

for example i have a query like this:

<select id="select1" resultClass="java.util.HashMap">
	SELECT sysdate today, 'dummy' dummy_field1, 'dummy' dummy_field2
FROM dual
</select>

then instead of returning complete date like 
	'Wed Mar 01 02:59:35 ICT 2006' 
it returned 
	'Wed Mar 01 00:00:00 ICT 2006'

but if the resultClass is not a map implementation, for ex:

<select id="select1" resultClass="java.util.Date">
	SELECT sysdate FROM dual
</select>

the it would return the correct value (complete with hours/min/secs).

Is there a solution to this?

Thank you,
Yusuf.


Mime
View raw message