dataSet GetXML

[z f]

the GetXML method of the DataSet returns date fields in the format:
2005-10-09T15:13:00.0000000+02:00
can this be changed?

TIA!!!

 

[Cor Ligthert [MVP]]

Hi,

You would have to be lucky that it is like this, it helps you to be able to
use in any culture.

You can use a string, from which I know that there are a few situations
where this can be done. However again, take care where you use this.

A date as 1-12-2005 given by somebody in another culture, can be meant what
is for you 12-1-2005. By instance if you have a program used in a Bank,
than you can probably understand what can be the result of this. The most
common used in the world are by the way yyyy-MM-dd hh:mm:ss and dd-MM-yyyy
hh:mm:ss.

(Also however very much less are used dd-MM-yyyy hh:mm:ss pm/am and
MM-dd-yyyy pm/am)

I hope this helps,

Cor

 

[z f]

this XML is transformed using XSL to HTML.
the problem is to change the format in XSL.
so if there is a flag to the DataSet in what format to output the date it
would be easier.
thanks.

 

[dima77]

I read excelent how to solve this
http://gregnozik.blogspot.com/2011/09/getxml-dataset-method-not-good-enough.html(e-mail address removed)