Turns out DateDiff is indeed different between the two so it won't work in my situation. Bugger.
On Mar 2, 1:53 pm, Colin Ramsay <[email protected]> wrote: > Thank you Tuna! > > On Mar 2, 1:34 pm, Tuna Toksoz <[email protected]> wrote: > > > I have no idea, it all depends on the functions, and its specific syntax. > > but in general, it should work, or i hope it will work. > > > Tuna > > Toksözhttp://tunatoksoz.comhttp://turkiyealt.nethttp://twitter.com/tehlike > > > Typos included to enhance the readers attention! > > > On Mon, Mar 2, 2009 at 3:33 PM, Colin Ramsay <[email protected]> wrote: > > > > Would that work even if I switched my config from SqlServer to MySQL - > > > i.e. does it depend on database-specific syntax? > > > > On Mar 2, 1:25 pm, Tuna Toksoz <[email protected]> wrote: > > > > You can use SqlFunctionProjection together with GreaterThan. > > > > Is that clear? > > > > > Tuna Toksözhttp://tunatoksoz.comhttp://turkiyealt.nethttp:// > > > twitter.com/tehlike > > > > > Typos included to enhance the readers attention! > > > > > On Mon, Mar 2, 2009 at 3:05 PM, Colin Ramsay <[email protected]> > > > wrote: > > > > > > Hi all, > > > > > > Given this data: > > > > > > Feed includedFeed = new Feed { > > > > > LastUploaded = DateTime.Now.AddHours(-6), > > > > > UploadFrequencyInHours = 5 > > > > > }; > > > > > > Feed excludedFeed = new Feed { > > > > > LastUploaded = DateTime.Now, > > > > > UploadFrequencyInHours = 5 > > > > > }; > > > > > > I would like to query the database using the criteria API to get > > > > > "pending feeds", ie. ones which have not been uploaded within the > > > > > UploadFrequencyInHours window. Something like this in SQL: > > > > > > WHERE (DateDiff(hh, LastUploaded, getdate()) >= > > > > > UploadFrequencyInHours) > > > > > > Is there a method of doing this with Criteria? > > > > > > Thanks, > > > > > Colin. --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
