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

Reply via email to