Re: [sqlite] best way to match a date but not a time?

2007-09-02 Thread C M
Thanks, Simon, Trey, and Dan, this is really helpful and has got me back on track. -CM On 9/2/07, Trey Mack <[EMAIL PROTECTED]> wrote: > > > I want to have queries that will match dates but not care about times. > > The date might be today, anything within the last week, month, year, > > or a

Re: [sqlite] best way to match a date but not a time?

2007-09-02 Thread Dan Kennedy
On Sun, 2007-09-02 at 11:13 -0400, Trey Mack wrote: > > I want to have queries that will match dates but not care about times. > > The date might be today, anything within the last week, month, year, > > or a range of dates. I'm using Python's datetime function, so the > > dates enter the

Re: [sqlite] best way to match a date but not a time?

2007-09-02 Thread Trey Mack
I want to have queries that will match dates but not care about times. The date might be today, anything within the last week, month, year, or a range of dates. I'm using Python's datetime function, so the dates enter the database in this format 2007-09-01 12:00:02. So far, < or > queries seem

Re: [sqlite] best way to match a date but not a time?

2007-09-02 Thread Simon Davies
On 02/09/07, C M <[EMAIL PROTECTED]> wrote: > Hi, I'm very new to SQLite, and I'm using it with Python. > > I want to have queries that will match dates but not care about times. . . . Hi, If your dates are stored in julian day (real) format, then the fractional part will indicate the time of

[sqlite] best way to match a date but not a time?

2007-09-02 Thread C M
Hi, I'm very new to SQLite, and I'm using it with Python. I want to have queries that will match dates but not care about times. The date might be today, anything within the last week, month, year, or a range of dates. I'm using Python's datetime function, so the dates enter the database in this