[eml-dev] [Bug 3096] - Date data type (domain) need be handled correctly

[bugzilla-daemon@ecoinformatics.org]

http://bugzilla.ecoinformatics.org/show_bug.cgi?id=3096





------- Comment #2 from leinfelder at nceas.ucsb.edu  2008-02-29 16:50 -------
implemented datetime handling in both the Postgres and HSQLDB adaptors.
Uses the format string supplied in the EML for the attribute.
For the Postgres adaptor, the mapping of the format strings is straightforward,
but for hsql I'm using the SimpleDateFormat to help parse the string into a
date and the Java conventions are a tad different than ISO 8601 (what we a re
using in EML).  I've included some manual conversions where there is no
ambiguity (ie. uppercase Y to lowercase y).  It is possible that we might
encounter more discrepancies as more people use this feature.

This change also means that the format string becomes very important - there is
case sensitivity lurking here and we cannot assume that "mm" (minute) really
means "MM" (month).  I'm sure there are many datapackages that have imperfect
format strings.