On Dec 13, 12:12 am, Dennis Lee Bieber <[EMAIL PROTECTED]> wrote:
> On Wed, 12 Dec 2007 16:02:35 -0800 (PST), [EMAIL PROTECTED] declaimed
> the following in comp.lang.python:
>
>
>
> > Thanks Duncan and John! That makes sense. But why does the official
> > Python docs show an example that seems to
On Dec 13, 1:54 am, Tim Roberts <[EMAIL PROTECTED]> wrote:
> [EMAIL PROTECTED] wrote:
>
> >I'll have to refactor my code somewhat to force it to use the '-MM-
> >DD' format.
>
> Another possible solution is to use a real database.
I am using a "real" database: MS SQL Server 2000. Unfortunat
[EMAIL PROTECTED] wrote:
>
>Thanks Duncan and John! That makes sense. But why does the official
>Python docs show an example that seems to imply that there is a "date"
>type? See link below:
You can certainly create fields of type "date" in sqlite, but sqlite
doesn't understand any types. **ALL**
On Dec 12, 2:53 pm, John Machin <[EMAIL PROTECTED]> wrote:
> On Dec 13, 7:22 am, [EMAIL PROTECTED] wrote:
>
>
>
> > Hi,
>
> > I am trying to use sqlite to create a local database for an
> > application I am writing and I am getting some screwy results from it.
> > Basically, I have a set of values
On Dec 13, 7:22 am, [EMAIL PROTECTED] wrote:
> Hi,
>
> I am trying to use sqlite to create a local database for an
> application I am writing and I am getting some screwy results from it.
> Basically, I have a set of values in the database and I am trying to
> select a date range and sum those valu
[EMAIL PROTECTED] wrote:
> So the data us there, but the sql only works part of the time. My SQL
> works if my database is in SQL Server, but not sqlite. Is my SQL
> malformed? Is it something about dates in sqlite? Or is it something
> else?
Your dateworked field seems to have strings rather tha
On 12/12/07, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
>
> "SELECT SUM(reg), SUM(ot), SUM(ce), SUM(hol), SUM(sklv), SUM(vac),
> SUM(ct), SUM(conv), SUM(misc) FROM tbl_TimeEntries WHERE dateworked >=
> '12/31/2006' AND dateworked <= '01/13/2007' AND empid = 281"
The first and third return the
Hi,
I am trying to use sqlite to create a local database for an
application I am writing and I am getting some screwy results from it.
Basically, I have a set of values in the database and I am trying to
select a date range and sum those values.
My problem is that it only sums up every other date
