Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <blockquote> <p>consider this: an integer can be conceptualized as either an absolute value (the point on the number line) or a distance between values</p> </blockquote> <p>By your logic, it isn't TimeSpan that's unecessary: rather it's DateTime that's unnecessary, and could be replaced by TimeSpan (duration since zero).</p> <p>Plus there's the fact that integers have an obvious zero, whereas Dates however don't have an obvious zero; but having an obvious zero is necessary, if you want to replace "place on the number line" with "distance/span from the zero/origin".</p> <hr> <p>Edit:</p> <p>A point (location on a plane) isn't the same as a vector.</p> <p>They seem similar ...</p> <ul> <li>A vector (distance from origin) can represent a point</li> <li>A point (relative to the origin) can represent a vector</li> </ul> <p>... however the value of the vector that's required to represent a given point will change if the origin changes.</p> <p>It always makes sense to add two (relative) vectors; but, it makes no sense to add two points, except by converting those points to vectors and then adding the vectors.</p> <p>The sum of two vectors is unaffected by a change in the origin, but the sum of two points would be affected by a change in the origin if you summed them by converting them to vectors and adding the vectors (because changing the origin would affect the values of those vectors).</p> <p>[Replace 'point' with DateTime and 'vector' with TimeSpan in the argument above.]</p> <p>I think there is a genuine difference between absolute and relative values. I'm don't know why that difference isn't more apparent in arithmetic, i.e. why 'numbers' are used seemingly interchangeably to represent both absolute and relative values.</p>
    singulars
    1. This table or related slice is empty.
    1. POIs TimeSpan unnecessary?
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USChrisW
    1. USChrisW
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. POIs TimeSpan unnecessary?
      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. COFair enough -- I suppose my main point should be that DateTime and TimeSpan could be combined, rather than that TimeSpan specifically should be eliminated.
      singulars
      1. PO
      1. USDan Tao
    2. COI disagree: by Dan's logic, there isn't really any difference between DateTime and TimeSpan. They are different instances of the same concept. So I think it's incorrect to say one of them obsoletes the other.
      singulars
      1. PO
      1. USJoren
    3. COAlso, integers only have an obvious zero because we arbitrarily defined one. Any coordinate or indexing system is relative.
      singulars
      1. PO
      1. USJoren
 

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