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
