Re: Converting timestamp to date for queries

From: Andrus Adamchik (andru..bjectstyle.org)
Date: Sat Jun 23 2007 - 04:14:51 EDT

  • Next message: Lachlan Deck: "Re: Automatically managing last_modif_date and modified_by columns"

    A DATE logically spans a 24 hour period, so if I understand what you
    are trying to do, you need a BETWEEN qualifier that spans that range
    of timestamps from 00:00:00 to 23:59:59.... on that date.

    Andrus

    On Jun 18, 2007, at 9:44 PM, Kevin Menard wrote:

    > 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 : Sat Jun 23 2007 - 04:15:17 EDT