Project

General

Profile

Actions

Feature #1574

closed

Dates with hours, minutes and seconds

Added by Alexander Watzinger over 2 years ago. Updated almost 2 years ago.

Status:
Closed
Priority:
Normal
Category:
Backend
Target version:
Start date:
2021-09-11
Estimated time:

Description

The INDIGO project will need dates with hours and minutes because if the data is already available (e.g. timestamps of pictures taken) we should track it.
We already use timestamp without time zone in the PostgreSQL database but we have to think about how to implement it in the user interface.

Implementation

We could call the option: dates_with_time and implement it similar to e.g. the "sub units" option:
  • Add this option at admin/modules to set a default for new user
  • Add this option at profile/modules for users to override
In the database we already save them as timestamp without time zone so they should be entered like that.
  • Forms: display 3 additional fields (hours/minutes/seconds) for dates if activated OR a time is already entered
  • Validate and process forms accordingly
  • Entity detail views: display time if not 00:00:00
Finishing
  • Update the manual accordingly
  • Adaptions at the API? (not sure if needed)

Related issues 1 (0 open1 closed)

Related to OpenAtlas - Feature #1675: API: 0.3 stable, 0.2 deprecated ClosedBernhard Koschiček-Krombholz2022-03-31Actions
Actions #1

Updated by Alexander Watzinger over 2 years ago

  • Target version changed from 252 to 7.4.0
Actions #2

Updated by Alexander Watzinger almost 2 years ago

  • Status changed from Acknowledged to Assigned
  • Assignee set to Bernhard Koschiček-Krombholz
Actions #3

Updated by Alexander Watzinger almost 2 years ago

  • Description updated (diff)

Updated description with suggested implementation details.

Actions #4

Updated by Bernhard Koschiček-Krombholz almost 2 years ago

Core functionality is done. Starting to implement profile options.

Actions #5

Updated by Alexander Watzinger almost 2 years ago

  • Related to Feature #1675: API: 0.3 stable, 0.2 deprecated added
Actions #6

Updated by Alexander Watzinger almost 2 years ago

As discussed, for API output I suggest to return dates with time. The API should deliver the raw data, formatting should happened where it is needed (e.g. presentation sites). I also linked this issue as related to #1675 because there, the API functionality changes anyway.
As API output format I suggest 2022-05-31 00:00:00 but not sure how to best format BC dates.

Actions #7

Updated by Alexander Watzinger almost 2 years ago

  • Status changed from Assigned to In Progress
Actions #8

Updated by Bernhard Koschiček-Krombholz almost 2 years ago

  • Status changed from In Progress to Closed

Feature in develop branch

Actions #9

Updated by Alexander Watzinger almost 2 years ago

  • Subject changed from Dates with hours and minutes to Dates with hours, minutes and seconds
Actions

Also available in: Atom PDF