Hi there,
my query is returning a recordset to VB, and then being built into an XML document using the DOM.
When dates are formatted into XML, I'm losing the time off the end of the date.
Eg, SQL returns "28-04-2004 11:13:01.233" but XML only shows "28-April-2004". How can I maintain the full SQL datetime in my XML?
Do I need to set a datatype on the XML attribute in VB? How do I do that?
Thank you.
Graeme
my query is returning a recordset to VB, and then being built into an XML document using the DOM.
When dates are formatted into XML, I'm losing the time off the end of the date.
Eg, SQL returns "28-04-2004 11:13:01.233" but XML only shows "28-April-2004". How can I maintain the full SQL datetime in my XML?
Do I need to set a datatype on the XML attribute in VB? How do I do that?
Thank you.
Graeme