You could create a sortable date format string. For example, convert the date to GMT and store it yyyy-mm-dd hh:mm:ss.nnn then store the timezone afterwards so you can convert back to the date/time in the timezone. On 25 Jan 2012 19:05, "Kesava Neeli" <nke...@gmail.com> wrote:
> Thanks. That's what I was doing for some date fields now. Store the date > in a well formatted string and then do conversions. But it becomes tough > when you want to build a query "get me all records in last day" and the > datastore for that object contains thousands of records. With the strings, > you need to iterate through all records, get a date and then do a > comparison. > > With "date" data type, you can rely on appengine to return correct data. > > -- > You received this message because you are subscribed to the Google Groups > "Google App Engine for Java" group. > To view this discussion on the web visit > https://groups.google.com/d/msg/google-appengine-java/-/7sg4mVI55SMJ. > To post to this group, send email to > google-appengine-java@googlegroups.com. > To unsubscribe from this group, send email to > google-appengine-java+unsubscr...@googlegroups.com. > For more options, visit this group at > http://groups.google.com/group/google-appengine-java?hl=en. > -- You received this message because you are subscribed to the Google Groups "Google App Engine for Java" group. To post to this group, send email to google-appengine-java@googlegroups.com. To unsubscribe from this group, send email to google-appengine-java+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/google-appengine-java?hl=en.
