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