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:

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:

To create a Time column, see the Creating a Column article.

Date/Time

This column type stores the time measured in seconds.

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 ( . )

The datetime can be written in the ISO 8601 format like shown below:

YYYY-MM-DD HH:MM:SS

Datetime elements are validated to meet the following criteria:

To create a Date/Time column, see the Creating a Column article.

Date/Time Specific

This column type stores the time measured in seconds.

In SimpleOne interface, it is displayed as an input field with a date and time picker.

This field type is mainly used in Schedules. 

The datetime can be written in the ISO 8601 format like shown below:

YYYY-MM-DD HH:MM:SS

Datetime elements are validated to meet the following criteria:

To create a Date/Time Specific column, see the Creating a Column article.