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.

Reply via email to