cayenne-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Andrus Adamchik <and...@objectstyle.org>
Subject Re: Converting timestamp to date for queries
Date Sat, 23 Jun 2007 08:14:51 GMT
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
>


Mime
View raw message