Implement Expanded Date/Time Format Validation (PEP-4)

[clnsmth]

Description

The list of valid date and time formats used for congruence checking between EML metadata and data entity contents has been updated according to the requirements outlined in PEP-4: Expanding the List of Supported Date and Time Formats for ECC and ezEML Congruence Checks.

This expanded list of formats is now ready for integration into PASTA's congruence checking processes.

Impacted Areas

The following areas of the PASTA codebase are likely to be affected by this update and will require review and modification:

• JavaScript Validation: The validateDate and isValidDate functions within validation.js will need to be updated to recognize the new date and time formats.
• Database Adapter: Methods within DatabaseAdapter.java responsible for transforming and validating datetime strings for database compatibility must be adapted to handle the expanded format list.
• HSQL Adapter: The custom to_timestamp method in HSQLAdapter.java, used for parsing and converting date strings to database-compatible timestamps, needs to be updated.
• Quality Reporting: The handling of quality and reports in QualityReport.java may need adjustments to correctly identify and report on valid date formats within datasets.