[fpc-pascal] Timezone information in a dataset datetimefield?

Reinier Olislagers reinierolislagers at gmail.com
Mon Jul 25 13:45:19 CEST 2011


On 25-7-2011 13:31, Ludo Brands wrote:
>> So you're saying that this: 
>> <ADateTime>2011-07-22T15:00:00+02:00</ADateTime>
>> can be simplified to this: <ADateTime>2011-07-22T15:00:00</ADateTime>
>> ?
> It does. It uses TZ to convert if specified but assumes local time if not
> specified. Tested this when importing access 2010 data.

Ok, that simplifies things a lot.

> I think you misunderstood me. All the schema information available should be
> specified correctly in the XML file. What is not relevant, IMHO, is the
> format in which it is presented as long it is correctly and fully
> interpreted by the importer. So if the access 2002 format you created fits
> the bill, then that should be sufficient. 
Totally agreed.

> There are for example a lot of
> presentation type of atttributes added in access 2010 (display width,
> locale, etc) which are not part of the real data schema. No reason to
> emulate (invent) these properties for our purpose.
Agreed.
I did see one improvement in your 2010 export: descending indexes are
supported as opposed to Access XP.... I'll tweak the format to spit that
out & see if Access XP can read it...


Regards,
Reinier



More information about the fpc-pascal mailing list