Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>(<strong>Update</strong>: See the final example at the bottom, but the rest is left as background.)</p> <p>You can add a day to the <code>Date</code> instance and see if the month changes (because JavaScript's <code>Date</code> object fixes up invalid day-of-month values intelligently), e.g.:</p> <pre><code>function isLastDay(dt) { var test = new Date(dt.getTime()), month = test.getMonth(); test.setDate(test.getDate() + 1); return test.getMonth() !== month; } </code></pre> <p><a href="http://jsbin.com/emoto4" rel="nofollow noreferrer">Gratuitous live example</a></p> <p>...or as <a href="https://stackoverflow.com/users/14860/paxdiablo">paxdiablo</a> pointed out, you can check the resulting day-of-month, which is probably faster (one fewer function call) and is definitely a bit shorter:</p> <pre><code>function isLastDay(dt) { var test = new Date(dt.getTime()); test.setDate(test.getDate() + 1); return test.getDate() === 1; } </code></pre> <p><a href="http://jsbin.com/emoto4/2" rel="nofollow noreferrer">Another gratuitous live example</a></p> <p>You could embed more logic in there to avoid creating the temporary date object if you liked since it's <em>really</em> only needed in February and the rest is just a table lookup, but the advantage of both of the above is that they defer <em>all</em> date math to the JavaScript engine. Creating the object is not going to be expensive enough to worry about.</p> <hr> <p>...and finally: Since the <a href="http://www.ecma-international.org/publications/standards/Ecma-262.htm" rel="nofollow noreferrer">JavaScript specification</a> requires (Section 15.9.1.1) that a day is <em>exactly</em> 86,400,000 milliseconds long (when in reality days <a href="http://en.wikipedia.org/wiki/Day#Leap_seconds" rel="nofollow noreferrer">vary in length</a> a bit), we can make the above even shorter by adding the day as we :</p> <pre><code>function isLastDay(dt) { return new Date(dt.getTime() + 86400000).getDate() === 1; } </code></pre> <p><a href="http://jsbin.com/emoto4/4" rel="nofollow noreferrer">Final gratuitous example</a></p>
    singulars
    1. This table or related slice is empty.
    1. POHow to validate date if is the last day of the month with javascript?
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USCommunity
    1. UST.J. Crowder
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. POHow to validate date if is the last day of the month with 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. CO+1, similar to what I posted (albeit checking if the day-of-month was 1 rather than the month being different) but you beat me with the code so I deleted it :-)
      singulars
      1. PO
      1. USpaxdiablo
    2. CO@paxdiablo: I was about to edit in your example...but you beat me to it. Thanks.
      singulars
      1. PO
      1. UST.J. Crowder
    3. CO@T.J. Crowder: This does not ensure it is the last day of the current month of the current year.
      singulars
      1. PO
      1. USShef
 

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