Hi Niklas,
I believe this is an issue that only affects the Admin Console. I've filed
this issue: http://code.google.com/p/googleappengine/issues/detail?id=878
It executes perfectly within an application.
-Marzia
On Thu, Nov 20, 2008 at 5:21 PM, niklasr <[EMAIL PROTECTED]> wrote:
>
> Many thanks! Problem solved with numeric form matching the expected
> result:
> SELECT * FROM thing WHERE date > DATETIME(2008,06,08,22,17,45) AND
> date < DATETIME(2008,06,08,22,17,46)
> SELECT * FROM thing WHERE date > DATETIME(2008,11,20,22,17,45)
>
> It's just that datetime string representations return error:
> SELECT * FROM thing WHERE date > DATETIME('2008-06-08 22:17.45')
> « An error has occurred while executing this query.
>
> SELECT * FROM thing WHERE date > DATETIME('2008-06-08 22:17.45') AND
> date < DATETIME('2008-06-08 22:17.46')
> « An error has occurred while executing this query.
>
> Niklas
>
> On Nov 20, 10:42 pm, Marzia Niccolai <[EMAIL PROTECTED]> wrote:
> > Hi Niklas,
> >
> > As stated above, you can not use the string literal to query, you must
> > include a DATETIME() wrapper around that argument. Additionally, since
> > milliseconds are not included, you would need to query something like
> this
> > to find a specific entity that accorded at 2008-06-08 22:17.45.xxxx:
> >
> > SELECT * FROM thing WHERE date > DATETIME(\'2008-06-08 22:17.45\') AND
> date
> > < DATETIME(\'2008-06-08 22:17.46\')
> >
> > -Marzia
> >
> > On Thu, Nov 20, 2008 at 1:09 PM, niklasr <[EMAIL PROTECTED]> wrote:
> >
> > > Thank you for replying, though it's still not matching from here.
> > > I've this is the datastore
> > > added YYYY-MM-DD HH:MM:SS
> > > value: 2008-06-08 22:17:45.200477
> > > type: gd:when
> >
> > > Still the following won't match
> > > SELECT * FROM thing WHERE added = '2008-06-08 22:17:45'
> >
> > > It should be trivial, but how?
> >
> > > regards
> > > Niklas
> >
> > > On Nov 20, 7:56 pm, Marzia Niccolai <[EMAIL PROTECTED]> wrote:
> > > > Hi,
> >
> > > > In order to query on DateTime objects, the following methods are
> > > supported
> > > > (fromhttp://
> code.google.com/appengine/docs/datastore/gqlreference.html):
> >
> > > > A datetime, date, or time literal, with either numeric values or a
> string
> > > > representation, in the following forms:
> > > > * DATETIME(year, month, day, hour, minute, second)
> > > > * DATETIME('YYYY-MM-DD HH:MM:SS') [no milliseconds]
> > > > * DATE(year, month, day)
> > > > * DATE('YYYY-MM-DD')
> > > > * TIME(hour, minute, second)
> > > > * TIME('HH:MM:SS')
> >
> > > > -Marzia
> >
> > > > On Wed, Nov 19, 2008 at 7:03 PM, niklasr <[EMAIL PROTECTED]> wrote:
> >
> > > > > SELECT * FROM thing WHERE added = '2008-06-08 22:17:45.200477 '
> > > > > won't match
> > > > > Neither
> > > > > SELECT * FROM thing WHERE added < '2008-07-08 22:17:45.200477 '
> and
> > > > > added > '2008-06-08 22:17:45.200477 '
> > > > > And
> > > > > SELECT * FROM Ad WHERE added < '2006-11-18 22:17:45.200477 '
> > > > > surprisingly matches many entities.
> >
> > > > > How match a day or a month interval, or an exact timepoint?
> >
>
--~--~---------~--~----~------------~-------~--~----~
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 [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/google-appengine?hl=en
-~----------~----~----~----~------~----~------~--~---
