Support > Repository > Definition of model items > Date and time type
ja | en

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.

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 date/time item is the same as the date type.Details are "Date type> Input filterPlease read.

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.