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 imply that
On Dec 13, 1:54 am, Tim Roberts [EMAIL PROTECTED] wrote:
[EMAIL PROTECTED] wrote:
snipped
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. Unfortunately,
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
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 correct
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 values.
[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 than
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 in the
[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** types