This might help.
http://souptonuts.sourceforge.net/readme_sqlite_tutorial.html
A quick glance through the date.c file in the Sqlite distribution is all
you needed to understand the extent and rationale behind the Sqlite date
support. You can also use the code there as a template to create your
own user functions for more detailed date manipulation.
Anderson, James H (IT) wrote:
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 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 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 (EXTRACT DAY FROM date) = 2005" does not
work.
The database was created with SQLite Analyzer 3.0.8. The datatyp of
the field date ist Text.
Thanks
Karsten
------------------------------------------------------------------------
-----
To unsubscribe, send email to [EMAIL PROTECTED]
------------------------------------------------------------------------
-----
--------------------------------------------------------
NOTICE: If received in error, please destroy and notify sender. Sender does not
intend to waive confidentiality or privilege. Use of this email is prohibited
when received in error.
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
