Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

datetime format from SQL in XSL

Status
Not open for further replies.

ResolutionsNET

IS-IT--Management
Jul 31, 2000
70
GB
Help,

I'm currently retrieving a datetime field from a SQL query, this being put through a DataSet and then converted to XML.

The XML is then transformed via a XSL. I know that XSL doesn't do dates and that you have to have a external call (function in ASP.NET), but U can't seem to transform the date returned into a displayable date. The date in the XML takes the format of 01/01/01T12:12:12.000000.

any ideas.
 
You should be able to cast that incoming data into a date type variable. If it doesn't recognized the format try manually casting it to a string on the other side first then back to a date That'l do donkey, that'l do
[bravo] Mark
If you are unsure of forum etiquette check here faq796-2540
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top