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.