search

protegeproject / cellfie-plugin

Protégé plugin for creating OWL ontologies from spreadsheets
106 stars 27 forks source link

UNIX timestamp conversion to ISO-8601 when using xsd:dateTime #59

Open johardi opened 8 years ago

johardi commented 8 years ago

Currently Cellfie will do nothing regarding the data as UNIX timestamp and it will just treat it as an ordinary string. The transformation will not produce the right date/time literal representation.

For example, a given raw data from Excel will produce a literal:

42516.2685532407^^xsd:dateTime

instead of:

2016-05-26T06:26:43^^xsd:dateTime

csnyulas commented 8 years ago

See email from our mailing list that reported this: http://protege-project.136.n4.nabble.com/Celfie-plugin-DateTime-format-issue-after-import-td4665423.html