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 -~----------~----~----~----~------~----~------~--~---
