Converting timestamp to date for queries

From: Kevin Menard (kmenar..ervprise.com)
Date: Mon Jun 18 2007 - 15:44:28 EDT

  • Next message: Malcolm Edgar: "Re: Common attributes in the model"

    Hi,

    I've been playing around with django a lot lately and they have a
    concept of "generic views", which basically is a way to list objects by
    date and/or slug. I decided to try doing this with my Tapestry 4 app,
    but have been running into problems. In particular, one of my models
    uses TIMESTAMP for its "pubDate" field. Generally, I do want to have
    both the date and time information, but I'd like to query by date and
    slug. It is assumed that there is a unique combination of both.

    Ex.:

    http://www.example.com/2007/06/18/some-slug-text

    I've been trying to build up a java.util.Date based on the information
    provided in that URL and pass it off to a named query. The query
    executes just dandy, but I get nothing back because the time values do
    not match. Is there anyway to do a type conversion and just compare by
    the date portion?

    Thanks,
    Kevin

    Kevin Menard
    Servprise International, Inc.
    800.832.3823 x308

    This archive was generated by hypermail 2.0.0 : Mon Jun 18 2007 - 15:45:04 EDT