On Tue, 2006-12-26 at 12:43 -0500, Anderson, James H (IT) wrote: > Where are the date support functions documented? >
On the wiki > -----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] > ----------------------------------------------------------------------------- > -- G. Roderick Singleton <[EMAIL PROTECTED]> PATH tech
smime.p7s
Description: S/MIME cryptographic signature
