> can convert to seconds since start of epoch, do the arithmetic, > then convert back
Don't get you. It would be quite a calculation, with leap years etc. RBS > 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] > ----------------------------------------------------------------------------- > > > ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
