Re: Converting timestamp to date for queries

2007-06-23 Thread Andrus Adamchik
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 dj

Re: Converting timestamp to date for queries

2007-06-19 Thread Mike Kienenberger
am not sure about what and why. kind regards peter -Ursprüngliche Nachricht- Von: Kevin Menard [mailto:[EMAIL PROTECTED] Gesendet: Montag, 18. Juni 2007 21:44 An: user@cayenne.apache.org Betreff: Converting timestamp to date for queries Hi, I've been playing around with django a lot

AW: Converting timestamp to date for queries

2007-06-18 Thread Peter Schröder
PROTECTED] Gesendet: Montag, 18. Juni 2007 21:44 An: user@cayenne.apache.org Betreff: Converting timestamp to date for queries 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

Converting timestamp to date for queries

2007-06-18 Thread Kevin Menard
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