On Thu January 19 2006 16:44, Rob Kudla wrote:
> you might be able to do "where strftime('%m', mydate) = 0" to
Sorry, I should have written
"where strftime('%m', mydate) = '01'"
because strftime returns a 1-based zero-padded string for %m, not
an 0-based integer.
Rob