Databases
StackOverflow2013
Commentsdbo
 
Search
scanning

Scanning is the default search option for small tables.

Enter text here to perform a scan over supported column types.

Text columns with limited length use a substring search If the entered text is a number, integer columns will be scanned for an exact match of the value.

The scanning search option is disabled for large tables.

seeking

Seeking is the default search option for large tables.

Seeking requires indexes and can only be done using the column (or columns) the index is defined on.

In the single-column case, the database will seek to the position the entered search term would be at and return all rows greater or equal to that value.

In the multiple-column case, the above still applies to the column you supplied non-empty search text for. All previous columns, however, will be using an equality match.

Id
PostId
PostIdCreationDate
› search options
UserIdCreationDate
 
 

Note that there are some explanatory texts on larger screens.

plurals
  1. COAlso, Decimal can't represent as wide a value as a Double. Decimal can only go up to +/-7.9228162514264337593543950335E+28; whereas a Double can go up to +/-1.79769313486232E+308
    primarykey
    data
    text
    singulars
    1. POConvert Decimal to Double?
      singulars
      1. PTQuestion
    1. USTraumaPony
  2. COwhat all of the answers so far have missed is that it depends where the person was born and where they are right now.
    primarykey
    data
    text
    singulars
    1. POHow do I calculate someone's age in C#?
      singulars
      1. PTQuestion
    1. USYaur
  3. CO@Yaur: Just convert the time of now + birth into GMT/UTC, age is only a relative value, hence timezones are irrelevant. For determining the user's current timezone, you can use GeoLocating.
    primarykey
    data
    text
    singulars
    1. POHow do I calculate someone's age in C#?
      singulars
      1. PTQuestion
    1. USStefan Steiger
  4. COWhy not consider [Julian Date][1]? [1]: http://stackoverflow.com/questions/7103064/java-calculate-the-number-of-days-between-two-dates/14278129#14278129
    primarykey
    data
    text
    singulars
    1. POHow do I calculate someone's age in C#?
      singulars
      1. PTQuestion
    1. USMuhammad Hewedy
  5. COWhat if you want to calculate a relative time from now to Future?
    primarykey
    data
    text
    singulars
    1. POCalculate relative time in C#
      singulars
      1. PTQuestion
    1. USJhonny D. Cano -Leftware-
  6. CO"< 48*60*60s" is a rather unconventional definition for "yesterday". If it's 9am on Wednesday, would you really think of 9:01am on Monday as "yesterday". I'd have thought an algorithm for yesterday or "n days ago" should consider before/after midnight.
    primarykey
    data
    text
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. USJoe
  7. COCompilers are usually pretty good at pre-calculating constant expressions, like 24 * 60 * 60, so you can directly use those instead of calculating it yourself to be 86400 and putting the original expression in comments
    primarykey
    data
    text
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. USzvolkov
  8. COnoticed that this function excludes weeks
    primarykey
    data
    text
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. USjray
  9. CO@bzlm I think I did for a project I was working on. My motivation here was to alert others that weeks were omitted from this code sample. As to how to do that, it seemed pretty straight forward to me.
    primarykey
    data
    text
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. USjray
...and more
 

Querying!

 
Guidance
A table list

Lists show table rows with slightly less information than detail views, therefore not requiring section labels.

This list shows the beginning of an entire table.

Search

Searching on lists works via indexes when the table is large. On the left you see input fields generated from viable indexes and an expandable report for all indexes that are unavailable for searching with the respective reasons.

Searching along indexes is called seeking and this is one of the main values that databases offer. The trivial alternative is scanning, which is potentially inefficient as it works by walking the entirety of the candidate rows to find the matches.

The offer to scan is given for small tables. Currently, this only works on text and integer columns and they are searched all at once.

Loading more

Loading more rows than the initial 10 results is also currently restricted to a single reloading of 100 entries.

A future version will keep auto-loading on scroll for tables that have suitable indexes.

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