xml export time problem

Silentpower

Hello,

I've a question about a xml export. When I export a table with a time field, my result is the time + the letter 'Z';

An example

<?xml version="1.0" encoding="UTF-16" standalone="no"?>
<scangegevens>
	<scangegeven>
		<Type>4</Type>
		<Datum>2005-05-04</Datum>
		<Tijd>10:30:12Z</Tijd>
		<Login>GEERT</Login>
		<LocatieIN>10</LocatieIN>
		<LocatieUIT>50</LocatieUIT>
		<OrderNr/>
		<OntvangstNr>65</OntvangstNr>
		<Barcode>4544</Barcode>
		<ArtikelNr>2004-S</ArtikelNr>
		<Eenheid>BAK</Eenheid>
		<Hoeveelheid>5</Hoeveelheid>
		<LotNr>654645</LotNr>
		<Temperatuur>5</Temperatuur>
	</scangegeven>
</scangegevens>

Does anyone know why there is a Z after the time?

Tnx

jhoek

From the description of the dateTime primitive XML data type in the Microsoft XML Core Services SDK:

[...]
This representation may be immediately followed by a "Z" to indicate Coordinated Universal Time (UTC) or to indicate the time zone. For example, the difference between the local time and Coordinated Universal Time, immediately followed by a sign, + or -, followed by the difference from UTC represented as hh:mm (minutes is required). If the time zone is included, both hours and minutes must be present.