thanks
On 10/21/2016 3:04 PM, Keith Medcalf wrote:
SQLite does not have a type of "TIMESTAMP". Only TEXT, INTEGER, REAL, and
BLOB. They type of the data in the field depends on what you are storing in it. What
are you storing in it (you cannot store Python objects, such as a datetime
unless all the offsets are the same.)
> -Original Message-
> From: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org]
> On Behalf Of David Raymond
> Sent: Friday, 21 October, 2016 13:43
> To: SQLite mailing list
> Subject: Re: [sqlite] Troubles matching variable as
SQLite does not have a type of "TIMESTAMP". Only TEXT, INTEGER, REAL, and
BLOB. They type of the data in the field depends on what you are storing in
it. What are you storing in it (you cannot store Python objects, such as a
datetime object, in an SQLite database, only TEXT, INTEGER, REAL or
a textual comparison against the other text entries in
there.
-Original Message-
From: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] On
Behalf Of Rick Kohrs
Sent: Friday, October 21, 2016 3:05 PM
To: sqlite-users@mailinglists.sqlite.org
Subject: [sqlite] Trouble
Using Python 3.19.
I am reading in a lines from an ever growing log file. Values from each
line of the log file are parsed and placed into a database. Each record
has a variable of type TIMESTAMP. Multiple records have the same the
same value for time stamp.
After a line is processed, I need
5 matches
Mail list logo