On Wed, Sep 16, 2009 at 9:16 AM, SHARMAQ Sistemas <pa...@sharmaq.com.br> 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? > >
The problem is that you probably haven't read the documentation of datetime functions. Please do so at http://www.sqlite.org/lang_datefunc.html -- Puneet Kishor _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users