Explain the point of utilization of date/time (time).

When selecting "time" from the three types of "date", "time", "date and time" in the date/time type, items for handling time are prepared.

Figure 1 Time type

Relationship with Java

Time-type items are internally managed as java.sql.Time class.

In Wagby, the entered value is corrected by "filter". "Filter" can be automatically corrected by the filter.This function is set automatically.
Both the Web form, upload update, and REST API are used in common for the filter.

The filter that can be selected in the time type item is the same as the date type.Details are "Date type> Input filterPlease read.

You can enter the time in the list box. Figures 2, 3, and 4 are input images of hour, hour, minute, minute, second.

Figure 2 "Hour" input (minutes and seconds are zero)

Figure 3 "Hourly minutes" input (seconds is zero)
Figure 4 "Hours-Seconds" Input

Definition method

From the "Input control" tab of the model item detail definition dialog, set the time input method to "use of list box".

Fig. 5 Time input method setting

You can set the rule to the choice prepared in the list box. Figure 6 shows an example of setting the rule "Start from 7 o'clock, every 3 hours" in time.

Figure 6 Rule setting for time options

Figure 7 shows an example in which minutes are set to "every 5 minutes" as well.

Rule setting for alternative choices in Fig. 7

Figure 7 shows an example in which seconds are set to "every 10 seconds".

Rule setting for options in Figure 8

Definition method

Set the rule in the right list of the time input method.(Figure 9)

Figure 9 Rule setting for time input method

Here is an example of rule setting.

Every hour from 7 o'clock to 23 o'clock.
7-23
Every 3 hours from 7 o'clock to 23 o'clock.
7-23,3
From 7 o'clock to 24 o'clock, minutes are every 5 minutes
7-24:5
Every 3 hours from 7 o'clock to 24 o'clock.Minutes are every 15 minutes.Seconds every 30 seconds
7-24,3:15:30

If the time input method is blank, enter the time directly in the text field. The input method when entering in the text field follows "output control> date and time> format".Here is an example.

Fig. 10 Time setting format format setting

HH:mm:ss

  • Time can be entered from 0 to 23, minutes and seconds can be entered from 0 to 59.
  • Enter hours, minutes, and seconds separated by blanks or colons (":") characters respectively.(Example 10 10 10 10 minutes will be 10 10 seconds)

HH:mm

  • Time can be entered from 0 to 23, minutes can range from 0 to 59.
  • Enter the hour and minute separating them with blanks or colons (":") characters.(Example 10 10 will be 10: 10 minutes)
  • You can not enter seconds.Even if you enter it, it will be ignored.

HHmmss

  • Time can be entered from 0 to 23, minutes and seconds can be entered from 0 to 59.
  • Enter hours, minutes, and seconds consecutively.(For example 101010 it will be 10:10:10 seconds.If it is 123, it will be 12:03:0.)

If you enter a value that does not match this rule, it will not be recognized as a time.It will be blank when saved.