Can someone help me with a SQL request?
The Table contains Date, as well as Year, Month and Day columns.
I would like to return a recordset that is made up of only COMPLETE YEARS,
from January to December.
Say my data starts on August 14, 1975 and ends with May 4, 2009.
How do I get just those records that start from January 1, 1976 to December
31, 2008, as those would be the only COMPLETE YEARS from January to December
in my table?
====================
Should I... (see John, I used the word 'should' rather than 'can' ;)
1. Grab the first record and last record only, then within my code determine
my Start and End dates (Jan..., Dec..). From that, use the Start and End to
get the data I need?
Or...
2. Is there a way that I'm not thinking of that would be better suited for
this?
Thank you.
Rick
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
