Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>The definition of "the number of months in the difference" is subject to a lot of interpretation. :-)</p> <p>You can get the year, month, and day of month from a JavaScript date object. Depending on what information you're looking for, you can use those to figure out how many months are between two points in time.</p> <p>For instance, off-the-cuff, this finds out how many <em>full months</em> lie between two dates, not counting partial months (e.g., excluding the month each date is in):</p> <pre><code>function monthDiff(d1, d2) { var months; months = (d2.getFullYear() - d1.getFullYear()) * 12; months -= d1.getMonth() + 1; months += d2.getMonth(); return months &lt;= 0 ? 0 : months; } monthDiff( new Date(2008, 10, 4), // November 4th, 2008 new Date(2010, 2, 12) // March 12th, 2010 ); // Result: 15: December 2008, all of 2009, and Jan &amp; Feb 2010 monthDiff( new Date(2010, 0, 1), // January 1st, 2010 new Date(2010, 2, 12) // March 12th, 2010 ); // Result: 1: February 2010 is the only full month between them monthDiff( new Date(2010, 1, 1), // February 1st, 2010 new Date(2010, 2, 12) // March 12th, 2010 ); // Result: 0: There are no *full* months between them </code></pre> <p>(Note that month values in JavaScript start with 0 = January.)</p> <p>Including fractional months in the above is much more complicated, because three days in a typical February is a larger fraction of that month (~10.714%) than three days in August (~9.677%), and of course even February is a moving target depending on whether it's a leap year.</p> <p>There are also some <a href="http://www.datejs.com/" rel="noreferrer">date and time libraries</a> available for JavaScript that probably make this sort of thing easier.</p>
    singulars
    1. This table or related slice is empty.
    1. PODifference in Months between two dates in JavaScript
      singulars
      1. PTQuestion
    1. PTAnswer
    1. UST.J. Crowder
    1. UST.J. Crowder
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PODifference in Months between two dates in JavaScript
      singulars
      1. PTQuestion
    1. This table or related slice is empty.
    1. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    3. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    1. COHave +1 for nuance.
      singulars
      1. PO
      1. USJonathan Feinberg
    2. CO@T.J.: +1 for your function, it's a good example of where the OP could start, but I would think that at least a "full" month should be counted for (e.g.) Feb 1st to March 31st :-)
      singulars
      1. PO
      1. USAndy E
    3. CO@Andy: Agreed, totally just a starting point. Re the full month between 2010/2/1 and 2010/3/31, aside from complicating things in a similar manner to fractional months, how would we handle 23:59:59 on 2010/2/1 to 00:00:01 on 2010/3/31? That's ~2 days short of a full month! ;-) Being thorough really would require a proper calendar, allowing for leap years, discontinuities (such as the Gregorian Adjustment in 1582), etc., since JavaScript Date objects can go backward about 285k years. But you can't really use JS Date objects for that sort of thing anyway, they don't handle leap seconds. :-)
      singulars
      1. PO
      1. UST.J. Crowder
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload