I don't. I suggest that each wrapper be adapted to its purpose. Light,
heavy, high level, low level or whatever. In other words use the
toolkit as a kit of tools.
Joe Wilson wrote:
How do you propose that someone adds support for an official SQLite DATE
type in the 100 or so SQLite wrappers
On 12/26/06, Joe Wilson <[EMAIL PROTECTED]> wrote:
How do you propose that someone adds support for an official SQLite DATE
type in the 100 or so SQLite wrappers/drivers for various languages
and operating systems to get them all to agree on this standard DATE type?
Only by making an official SQ
How do you propose that someone adds support for an official SQLite DATE
type in the 100 or so SQLite wrappers/drivers for various languages
and operating systems to get them all to agree on this standard DATE type?
Only by making an official SQLite DATE type in the SQLite distro
can you acheive
If drivers and such concern you the solution is obvious, implement the
DATE type in the driver or "wrapper". Sqlite's basic architecture makes
it simple.
The Sqlite library is correct in being light and biased towards a small
footprint for embedded applications. Adding layers of software to
SQLite advocacy aside, I was just addressing your original statement:
Most Sqlite users know that Sqlite implements a DATE type
which is not strictly true.
Me, you and most SQLite users have seperately come up with conventions
to handle their particular date usage patterns. There is no disput
From my perspective Sqlite does implement a DATE type by having the
function support for an epoch based date stored in a floating point
number plus declared types. The Sqlite epoch appears to be the
theoretically correct one based on an epoch somewhere in antiquity and
compatible with all the
SQLite has no explicit DATE type, and the programmer has to rely
on convention, as previously mentioned. But that does not diminish the
value of the various date functions that SQLite provides.
SQLite version 3.3.8
Enter ".help" for instructions
sqlite> create table d1(a DATE, b DATETIME);
sql
You can declare your date columns as type DATE and Sqlite will store
that as a declared type. It stores the actual type according to how you
use the column, according to its manifest typing rules. You could use
the Sqlite built in date functions to store a date as a floating point
number base
Thanks!
-Original Message-
From: John Stanton [mailto:[EMAIL PROTECTED]
Sent: Tuesday, December 26, 2006 1:02 PM
To: sqlite-users@sqlite.org
Subject: Re: [sqlite] date - SQL extraction from day, month and year
This might help.
http://souptonuts.sourceforge.net
lite.org
> Subject: Re: [sqlite] date - SQL extraction from day, month and year
>
> Everybody? Most Sqlite users know that Sqlite implements a DATE type
> and has date support functions.
>
> Karsten Koschinski wrote:
> > Hey,
> >
> > I have a database with a fie
: [sqlite] date - SQL extraction from day, month and year
Everybody? Most Sqlite users know that Sqlite implements a DATE type
and has date support functions.
Karsten Koschinski wrote:
Hey,
I have a database with a field where dates are stored! As everybody
knows SQLite has no special date
DATE is more of a psuedo-type in SQLite that relies on programmer
convention. It is usually represented as text or as a number of
seconds since the epoch.
sqlite> select typeof(date('now'));
text
sqlite> select typeof(datetime('now'));
text
I think a proper date/time type in SQLite wou
Where are the date support functions documented?
-Original Message-
From: John Stanton [mailto:[EMAIL PROTECTED]
Sent: Tuesday, December 26, 2006 12:40 PM
To: sqlite-users@sqlite.org
Subject: Re: [sqlite] date - SQL extraction from day, month and year
Everybody? Most Sqlite users know
Everybody? Most Sqlite users know that Sqlite implements a DATE type
and has date support functions.
Karsten Koschinski wrote:
Hey,
I have a database with a field where dates are stored! As everybody knows
SQLite has no special date support such as a special datatype for date or
something e
lto:[EMAIL PROTECTED]
Sent: 26 December 2006 17:12
To: sqlite-users@sqlite.org
Subject: [sqlite] date - SQL extraction from day, month and year
Hey,
I have a database with a field where dates are stored! As everybody knows
SQLite has no special date support such as a special datatype for date or
s
Hey,
I have a database with a field where dates are stored! As everybody knows
SQLite has no special date support such as a special datatype for date or
something else. Now I want to select only those records, where the year ist
e.g. 2005. How can I do this?
"SELECT * FROM database WHERE (EXTR
16 matches
Mail list logo