Hello I read http://www.sqlite.org/lang_datefunc.html, but I still don't know how to extract the year from a table where a column has dates formatted as YYYY-MM-DD.
Currently, I use this, but I'm sure there's a better way: ====== //Find all invoices sent in 2009 SELECT * FROM invoices,phones WHERE phones_nbr=invoices_phones_nbr AND invoices_date_sent GLOB '2009-*' ====== Thank you for any info. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users