Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>Well, separate hours and minutes fields is the safest but slower to use than a single field. You can default the hours to 0 if you don’t expect many durations over 1 hour.</p> <p>Maybe it depends on your population, but I expect users will be able to handle hours and minutes in the same text box if you provide a prompt, such as “Time duration (hrs:min):” </p> <p>With that prompt, accept any initial unbroken string of numbers as the hours and any subsequent unbroken string of numbers as minutes, so that all of the following input are treated as equivalent.</p> <ul> <li><p>2:30</p></li> <li><p>02:30</p></li> <li><p>02:30:05</p></li> <li><p>2.30 (or maybe not: while great for keypad entry, but you may want to make an exception for the decimal point to allow the user to enter fractional hours, such as 2.75 for 2 hrs 45 min.)</p></li> <li><p>2 30</p></li> <li><p>2 hrs 30 min</p></li> <li><p>2 hours, 30 minutes</p></li> <li><p>2jaQp 30!!!!</p></li> </ul> <p>I see no reason to require that the minutes be less than 60. The user should also be able to express the time as:</p> <ul> <li>:150</li> </ul> <p>When the focus leaves the field, auto-correct whatever the users enter to the specified (hrs:min) format to feedback the interpretation you made.</p> <p>If all you need for your purpose is a rough approximation of time (or your users are only estimating anyway), then consider option buttons or a dropdown list with ranges of duration (e.g., 0 to 5 minutes, 5 to 15 minutes, 15 min to 1 hour, Over an hour.). Or if there are definite bounds on the durations and the intervals are functionally linear, you can use a labeled slider.</p> <p>Whatever input format or control you use, it should be compatible with the source of information. Where do users get this duration? What units, format, intervals, and degree of precision are used there? How do users think and talk about the time among themselves?</p>
    singulars
    1. This table or related slice is empty.
    1. POUI for capturing a timespan or duration
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USMichael Zuschlag
    1. USMichael Zuschlag
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    1. COYour example of :150 will not work with the rest of the answer as it will be interpreted as 150 hours. Anyway, I don't think this freedom is any good for the user as it is something he will not expect and generally will not know how to use it
      singulars
      1. PO
      1. USJosef Sábl
    2. COBy "initial string of numbers" I meant the initial string when it begins with a numeral, so :150 has no initial string of numbers, so hours are 0 and minutes are 150. I can't see how unexpected freedom will be a problem. Most users will never discover it (they'll never think of typing "2 30"), but those that do may find it useful (typing a colon is relatively awkward on many keyboards). Unexpected _limitations_ --now _that's_ a problem.
      singulars
      1. PO
      1. USMichael Zuschlag
 

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