Date, Time, and DateTime Data Types represent temporal values. The system can display each temporal value in different formats depending on the data or user needs (e.g., 6 Aug 2021, 06/08/2021).
For this purpose, three different data types will be available for storing date and time data:
Used for values with a date part only. Keeps track of days in the format YYYY-MM-DD
.
Used for values representing a time of day in hours, minutes, seconds, and optional fractions of seconds in the format hh:mm:ss
.
Used for values that contain both date and time parts in the format YYYY-MM-DD hh:mm:ss
.
Date, Time and DateTime Data Type Options
Date, Time, and DateTime Data Types should allow users to set display options to present the data in formats different from how the values are stored.
A Date, Time, or DateTime data type is set and the user can now input values with a date or time picker or manually. The system will restrict the allowed values based on the set format.
If the system can’t parse the values, the system will not set a Date, Time, or DateTime data type. The user will receive a warning, and if they choose to proceed, the system will empty the column values.
When entering values in a column set to a Date, Time, or DateTime data type, the users will be able to do so from a date or time picker for easier input.
Values in a ‘Date and Time’ data type column can be filtered by various parameters such as specific date, a range of dates, dates after or before a certain date, and also by using natural language phrases like “now,” “today,” “next week,” “next month.”
Values in a Date, Time, or DateTime data type column can be grouped by different date and time units. Depending on the user’s chosen data type, the options might include the date and time-specific units or not.