Did you try to put 1946 without quotes? Pavel
On Wed, Sep 16, 2009 at 12:21 PM, vbshar <[email protected]> wrote: > > Hi, > > I have a table called PEOPLE with 2 fiels: > > NAME à TEXT 40 > BIRTH à DATETIME > > With some records > > I want to filter all people with BIRTH = 1946, I’m trying this: > > SELECT * FROM PEOPLE WHERE YEAR(PEOPLE.BIRTH)=’1946’; > > There are several people in this year, but recordset all time returns 0 > records… what's the problem? > > > Best Regards > Paulo > -- > View this message in context: > http://www.nabble.com/Select-records-by-specific-YEAR-tp25475857p25475857.html > Sent from the SQLite mailing list archive at Nabble.com. > > _______________________________________________ > sqlite-users mailing list > [email protected] > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
