Need help with Hibernate? Read this first:
http://www.hibernate.org/ForumMailingli ... AskForHelp

[b]Hibernate version:[/b]
Hibernate Synchronizer
[b]Mapping documents:[/b]
hibernate-mapping-2.0.dtd
[b]Name and version of the database you are using:[/b]
DB2

dear all,
i need to calculate the date range between 2 date , my hql goes like this:

select '2005-07-18 00:00:00.0'-AL.DtDocumentDate
from tableA as AL where AL.SiRecordStatus = 1
and AL.DtDocumentDate <= '2005-07-18 00:00:00.0'
and AL.BiDebtor =11 and AL.ChClass='I'

and i got the error message like following :

net.sf.hibernate.QueryException: undefined alias: '2005-07-18 00:00:00 [select '2005-07-18 00:00:00.0'-AL.DtDocumentDate from com.ifca.mcorp.hh.ArdmxLedger as AL where AL.SiRecordStatus = 1 and AL.DtDocumentDate <= '2005-07-18 00:00:00.0' and AL.BiDebtor =11 and AL.ChClass='I']

- hibernate just didnt regconised the date . when i select date out from database , is in timestamp format , so i try to use timestamp for my given date .. but result is the same ...

hope can get any help from u all.
tans ! :)

This worked for me:



I don't think you're supposed to have the actual literal date value as one of the fields to select.

--Jesse

hi, tans for ur reply .
yeah , i think it is not possible for me to get the difference by my above hql . so , as alternative way , i just select out the date and then do my calculation myself.
anyway , tans for ur reply .
:)

I'm pretty new to Hibernate and HQL, but most databases have various date/time manipulation functions built in, including something like DATE_SUB(). If those built in functions are available from within HQL, then you can use them to do your subtraction.

--sam

Hi,
my opinion is: let the database do its work - the data persistance - and let the code do its work - the processing -.
In other words, even if from a SQL point of view it is correct, I wouldn't write such a query in Hibernate.
I think you should add some methods for date calculations - such as add, substract, days, etc. - or to the class containing the date property or, in a more general way, to a user type extending Date.
Cheers
Adriano