you can do it in the .NET language.the DateTime class has some methods to add values to calc the result of a datetime + days, hours and etc... then you can just fill the parameter result. you dont need to do it in hql.
Plácido Bisneto 2009/6/1 [email protected] <[email protected]> > > I have the following HQL WHERE clause: > > where tbl1.DateTimeField + tbl2.TimeSpanField > >= :someDateTimeParameter > > this translates pretty much literally into TSQL. However, such TSQL is > invalid, as you can't add a DateTime to a BigInt (my timespan). > > How do I solve this problem? Is there some HQL trick i can employ, or > do i need some TSQL UDF? If so, what would the UDF need to look like > and how do i call if from HQL? > > Thanks > > Andrew > > > --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "nhusers" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/nhusers?hl=en -~----------~----~----~----~------~----~------~--~---
