On Sun, 11 Oct 2009, Igor Tandetnik wrote: > I simply combine (month, day) pair into a single number - the same way you > combine two digits of a decimal number by multiplying the first by 10 and > adding the second. The multiplier doesn't have to be 100 - any number > greater than 31 will do.
Igor, Would it not be easier to use the DATE column and STRFTIME()? Specifying start and end dates as YYYY-MM-DD removes the need for such manipulations and will work within a single year as well as over multi-year spans. I ask because that's the way I would approach the solution to the question Rick asked. The MONTH and DAY columns seem repetitive to me and a potential souce of loss of integrity. If those columns are filled by extracting the appropriate portions of the DATE column, why not use the latter itself? Curious minds want to know, Rich _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
