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/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] ------------------------------------------------------------------------ ----- -------------------------------------------------------- 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] -----------------------------------------------------------------------------