I think the problem is in field format ou data format, because if i insert data from my app SQLite does not return any value, but if i insert data with the manager "SQLite developer"; the query works...
Pavel Ivanov-2 wrote: > > 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 > > -- View this message in context: http://www.nabble.com/Select-records-by-specific-YEAR-tp25475857p25476648.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
