Dates in iBatis

[Neverov Dm]

Hi, 

explain please why I get error using such statement:

<statement ...>
           select t.d - #dn:DATETIME#
           from table1 t
</statement>

Oracle database is used.

I try to use statement:
<statement ...>
           select t.d - to_date(#dn#, 'dd.mm.yyyy hh24:mi')
           from table1 t
</statement>

#dn# in this statement is of type String, but I also get errors.

-- 
Thanks.
mailto:[EMAIL PROTECTED]