Re: Dates in iBatis

[Mark Bennett]

You may want to post the actual error.  Here is how to enable the logging.  Also the ellipsis (...) may be hiding mistakes as well.

http://opensource2.atlassian.com/confluence/oss/display/IBATIS/How+do+I+get+SqlMapClient+to+log+SQL+statements

Mark

On 1/26/06, Neverov Dm < [EMAIL PROTECTED]> wrote:

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]