Unfortunately, it looks that just adds 30 days, so 16 Feb 06 will give 18 March 06 etc.
RBS >> 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] > ----------------------------------------------------------------------------- > > > ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
