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