On Sep 14, 2013, at 4:24 AM, James K. Lowden <jklow...@schemamania.org> wrote:
>> Why not
>> SELECT * FROM "entry" WHERE
>> bankdate >= date('now','start of month')
>> AND bankdate < date('now','start of month','+1 month')
>
> The half-open interval strikes again! :-)
Yeah... not sure why people are doing that to themselves though :D
bankdate between start_of_month and end_of_month
… now that reads much better :))
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
