ah... with DATEADD take care to use abbreviation instead full name...dateadd(dd, :addition, yourdate) instead dateadd(day, :addition, yourdate) dateadd(mm, :addition, yourdate) instead dateadd(month, :addition, yourdate) etc. etc.
2009/6/1 Fabio Maulo <[email protected]> > http://technet.microsoft.com/en-us/library/ms186819.aspx > > 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 >> >> >> > > > -- > Fabio Maulo > -- Fabio Maulo --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
