ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Neverov Dm <neverov...@nkmk.ru>
Subject Dates in iBatis
Date Thu, 26 Jan 2006 10:00:17 GMT
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:neverov_dg@nkmk.ru





Mime
View raw message