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? Paulo Cezar _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
