In SimpleOne, the date and datetime columns are commonly used in schedules, business rules, task management, logs, etc.
Date
Database stores the value of this column type in the ISO 8601 format: YYYY-MM-DD and does not specify the time of the day. The data stored is 4 bytes.
In SimpleOne interface, it is displayed as an input field with a date picker.
According to the date format of the current user, the field can contain:
- Numbers
- Slash ( / )
- Hyphen ( - )
- Dot ( . )
Date elements are validated to meet the following criteria:
| Element | Range | Comment |
|---|---|---|
| Day | [01..31] | The value specified should not exceed this range. |
| Month | [01..12] | The value specified should not exceed this range. |
| Year | [1000...] | The value specified should not exceed this range. |
To create a Date column, see the Creating a Column article.
Time
This column type is used for storing time in the ISO 8601 format: hh:mm:ss. Timezone is not taken into account. The date is not stored. Size of the stored data – 8 bytes.
The allowed symbols are numbers and a colon ( : ).
According to the date format of the current user, the field can contain:
- Numbers
- Slash ( / )
- Hyphen ( - )
- Dot ( . )
Time stamp elements are validated to meet the following criteria:
| Element | Range | Comment |
|---|---|---|
| Second | [00..59] | The value specified should not exceed this range. |
| Minute | [00..59] | The value specified should not exceed this range. |
| Hour | [00..23] | The value specified should not exceed this range. |
To create a Time column, see the Creating a Column article.
Date/Time
This column type stores the time measured in seconds. The datetime is stored in the ISO 8601 format: YYYY-MM-DD hh:mm:ss.
In SimpleOne interface, it is displayed as an input field with a date and time picker.
According to the date format of the current user, the field can contain:
- Numbers
- Slash ( / )
- Hyphen ( - )
- Dot ( . )
Datetime elements are validated to meet the following criteria:
| Element | Range | Comment |
|---|---|---|
| Second | [00..59] | The value specified should not exceed this range. |
| Minute | [00..59] | The value specified should not exceed this range. |
| Hour | [00..23] | The value specified should not exceed this range. |
| Day | [01..31] | The value specified should not exceed this range. |
| Month | [01..12] | The value specified should not exceed this range. |
| Year | [1000..9999] | The value specified should not exceed this range. |
To create a Date/Time column, see the Creating a Column article.
Date/Time Specific
This column type stores the time measured in seconds. The datetime is stored in the ISO 8601 format: YYYY-MM-DD hh:mm:ss.
In SimpleOne interface, it is displayed as an input field with a date and time picker.
This field type is mainly used in Schedules.
In contrast to the Date/Time field type, Date/Time Specific field type uses the UTC offset parameter defined in the system timezone. That is, the datetime is stored in the database as it is, without any offset.
Datetime elements are validated to meet the following criteria:
| Element | Range | Comment |
|---|---|---|
| Second | [00..59] | The value specified should not exceed this range. |
| Minute | [00..59] | The value specified should not exceed this range. |
| Hour | [00..23] | The value specified should not exceed this range. |
| Day | [01..31] | The value specified should not exceed this range. |
| Month | [01..12] | The value specified should not exceed this range. |
| Year | [1000..9999] | The value specified should not exceed this range. |
To create a Date/Time Specific column, see the Creating a Column article.
