db-torque-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Thomas Fischer <fisc...@seitenbau.net>
Subject RE: convert/cast sql expression
Date Tue, 25 Mar 2008 17:10:28 GMT

Seems like Criteria.CUSTOM is what you need. See


section "Using the CUSTOM modifier to use custom SQL"

   Hope this helps,


"Andre Steinmetzger" <Andre.Steinmetzger@cimt-ag.de> schrieb am 25.03.2008

> Hallo I`m using torque 3.2 and search for a methode to create a convert
> cast expression in the final sql. The target database is DB2. I hope
> can help me.
> e.g. The column plz is a character datatyp and I like to use something
like that:
>         select * from dim.region where integer(dim.region.plz) between
10000 and 12000
> Thanks. Andre

To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
For additional commands, e-mail: torque-user-help@db.apache.org

View raw message