Support > Repository > Model item > Date Time

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

If you select "Date and time" from date, time type "date" "time" "date and time", items to handle date and time are prepared.It handles year, month, day and time at the same time, year can be specified in the range from 1753 to 9999.

Figure 1 Date Time Type

Relationship with Java

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

The entered value is corrected by "filter".For details, please read "Input filter specifications".

The filter that can be selected in the date/time item is the same as the date type.For details, please read "Date Type> Input Filter".

When "Use Calendar" is specified for "Input control> Date/time type> Date input method", an input field as shown in Fig. 2 is prepared.

Fig. 2 Input field of date/time type item

With the mouse, you can move the cursor to the input field with the mouse and manually enter it.(If you reselect the date, the time returns to zero.)

It is currently unsupported to enter the date and time in the list box.It is a plan to cope with future Wagby.

If the date input method is blank, enter the date and 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. 3 Format setting of date time input method

yyyy-MM-dd HH:mm:ss

  • Enter the year as 4-digit year.
  • Enter the month from 1 to 12.
  • Enter the day in the range from 1 to 31.
  • Time can be entered from 0 to 23, minutes and seconds can be entered from 0 to 59.
  • Separate by year, month, day separately with blanks.Enter hours, minutes, and seconds separated by blanks or colons (":") characters respectively.(For example 2014 1 2 3 4 5 it will be 3:04:5, January 2, 2014)

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