[xsl] esql does not handle to_date function in SQL

["Ibeling, Narisa" <narisa.h.ibeling@xxxxxxxxxxxxx>]

Hi, there.

Here is my xml source:

<sql:execute-query xmlns:sql="http://apache.org/cocoon/SQL/2.0";>
        <sql:use-connection>personnel</sql:use-connection>
        <sql:query>
           select count(pt)
            from adv_7760$rollsnap.thro 
            where study = 'ADV_7760'
            and vpos = 'aortic'
            and to_date(event_date,'yyyymmdd') - to_date(implant_date,'yyyymmdd') <= 30 
            and thrombosed_etiology = 'primary event'
        </sql:query>
</sql:execute-query>

I am using cocoon to transform the results into xml.  My problem is cocoon is confused with to_date function.  It cannot process the query.  If I take the line with the to_date function, it works.  Is there any way I can accomplish the query in other ways?

Thanks in advance for your help.

Narisa Ibeling
Medtronic Cardiac Surgery



 XSL-List info and archive:  http://www.mulberrytech.com/xsl/xsl-list