Hi,
I have a table that has values stored on the hour, stored in a
DATETIME field. I'm trying to write a query where the date is
irrellevant, it's the time it was stored that matters (for example, to
extract the value at midnight every day).
I've tried the following with no success - dateindex is a DATETIME
field.
SELECT * FROM Trend24Hr WHERE dateindex = TIME('00:00:00')
It returns no result when I know there are some. Is there some way I
can do this?
If not, what options do I have?
I could refactor all the values into seperate DATE and TIME fields
(painful and annoying for several reasons) or I could extract ALL the
values for the date ranges and only deal with the those that are the
right hour in my result set (this seems very inefficient as I'll be
ignoring 23 values for every 1 I need). This second approach really
limits me to only ever dealing with a months worth of data when I'd
prefer three months as well.
Thanks!
Tim
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
