On Sun, Dec 03, 2006 at 05:31:55PM +0000, RB Smissaert wrote: > Still have the problem though how to compare dates in SQLite when the format > is the integer yyyymmdd. Maybe I will need some custom SQLite function.
What's difficult about comparing integers of the form yyyymmdd? Comparing them is easy: normal integer comparison operators work just fine. Date arithmetic with yyyymmdd integers, OTOH, is more difficult; but you can convert to seconds since start of epoch, do the arithmetic, then convert back. Nico -- ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
