gql as below works. SELECT * FROM Image where added > DATETIME(2009,1,1,0,0,0) and added < DATETIME(2009,2,1,0,0,0) we must use the integer form (the manual lists b0rked forms) http://code.google.com/p/googleappengine/issues/detail?id=878 cheers niklas
On Feb 3, 12:02 pm, arnie <parvez...@rediffmail.com> wrote: > For a datastore table with two db.DateTimeProperty columns start_date > and end_date, i need to use a date range in query but below given > query is not working > current_date=datetime.datetime.strptime(self.request.get > ('current_date'), '%Y-%m-%dT%H:%M:%S') > > db.GqlQuery('SELECT * FROM myTable where start_date>=:cdate and > end_date<=:cdate',cdate=current_date) > in the parameters I am passing current_date=2009-01-10T00:00:00 > Should we not compare dates this way? > But this is not working --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Google App Engine" group. To post to this group, send email to google-appengine@googlegroups.com To unsubscribe from this group, send email to google-appengine+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/google-appengine?hl=en -~----------~----~----~----~------~----~------~--~---