I made a SQLServer database structure based on an XSD schema I got. In that schema two fields have gml:TimePeriodType. In database I put two columns for each field of this type (begin and end) and the datatype is datetime. I use FME to translate database into GML, and then MapForce to map that GML to XSD schema.
I supposed that I can map begin and end column to some attributes of TimePeriod columns in my XSD schema. But (guess), I cannot do it. Can some help me what I need to do and where I am wrong?
FME is translating this columns into string (e.g. 20140522000000.000), which is weird to me (I think I need 2014-05-22T00:00:00 format).
What I am missing?
Sorry if question is stupid, but I am new to all of this, and I need pointers for going forward.