dataTime datatype converted to string in importing excel file to protege using Celfie Plugin,
Opened this issue · 2 comments
Rawrversio commented
I am working on Protege 5.0 with the plugin Celfie. I have imported an excel sheet which has a column Start_Time (datatype dateTime). When i import the excel sheet into protege, it converts the rows from dateTime format to a string or some other data type. I want to use that column for a data property having the data type DateTime.
3/5/2008 9:29 AM is converted to 39503.01.....
I need suggestions on how to convert it back to Datetime format in Protege .
johardi commented
Hi Rawrversio,
you can follow the steps from the discussion in the Protege-user mailing list here: http://protege-project.136.n4.nabble.com/Celfie-plugin-DateTime-format-issue-after-import-td4665423.html
Let me know if that works well for you too.