> If you have two dates A and B, you can ask the question: > Is A more than one month after B like this:
> SELECT julianday(A,'+1 month')>B ... Thanks; that looks exactly what I need. RBS -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: 18 December 2006 01:52 To: sqlite-users@sqlite.org Subject: Re: [sqlite] Calculate years and months difference with Julian Date? "RB Smissaert" <[EMAIL PROTECTED]> wrote: > Is it possible with Julian dates in 2 fields to calculate the months and/or > years difference between those 2 dates? > > I know I can subtract the 2 dates and divide by 30 (or 30.42) or 365 and > take it from there, but I would like it a bit more precise, so for example: > Is 2 March 2006 more than one month after 1 February 2006? > If calculated with a simple division the answer would be no, but I would > like it to be yes. > > Had a look at the date/time functions on the WIKI site, but couldn't see it. > If you have two dates A and B, you can ask the question: Is A more than one month after B like this: SELECT julianday(A,'+1 month')>B ... If you really need to know the number of months difference between A and B, then perhaps something like this: SELECT (strftime('%m',A)+12*strftime('%Y',A)) - (strftime('%m',B)+12*strftime('%Y',B)) ... Caution: Both of the above are off the top of my head and are untested. But perhaps they will give you some ideas. -- D. Richard Hipp <[EMAIL PROTECTED]> ---------------------------------------------------------------------------- - To unsubscribe, send email to [EMAIL PROTECTED] ---------------------------------------------------------------------------- - ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------