Skip to content

Add proper startTime and endTime fields that use time instead of short  #8567

Description

@bronwyncombs

Is your feature request related to a problem? Please describe.

The Collecting Information startTime and endTime fields, described as "Start/End time in military format." in our schema, are short/java.lang.short field type.

The accepted entires for short fields must be whole numbers between -32768 and 32768. Meaning, what should be valid Start and End Time values, e.g., 18:00, 10:30, 12:54, aren't accepted.

The DwC eventTime term (http://rs.tdwg.org/dwc/terms/eventTime) is defined as "The time or interval during which a dwc:Event occurred."

  • Notes: Recommended best practice is to use a time of day that conforms to ISO 8601-1:2019.
  • Examples:
    • 14:07-06:00 (at or after 2:07pm and before 2:08pm in the time zone six hours earlier than UTC)
    • 08:40:21Z (at or after 8:40:21am and before 8:41:22am UTC)
    • 13:00:00Z/15:30:00Z (at or after 1pm and before 3:30pm UTC) |

Describe the solution you'd like
Change the startTime and endTime field types to a string or text field that allows a : character.

Reported By
Father Saturnino Urios University

Activity

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Metadata

Metadata

Assignees

No one assigned

    Labels

    2 - Database/SchemaIssues that are related to the underlying database and schema2 - Exporting DataIssues that are related to exporting data to DwC, GBIF, IPT, Web Portal, etc.

    Projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions