Change date format in XSLT 3

[abs2003]

Hi all,

How can format my date as mm/dd/yyyy in XSLT?
My SQL Server's datetime field contains "5/3/2005 2:48:41 PM".
My XSLT code

<xsl:value-of select="StartDate"/>

. My output: "2005-05-03T14:48:41.0000000-04:00" which looks weird.

Help please,

abs

 

[k5tm]

Consider substring()

 

[simonchristieis]

assuming you are using for xml explicit within your sql to create the xml why not just convert on the sql server ?

convert(varchar(10),dStartDate,103)



?

 

[JontyMC]

Or use:

<xsl:value-of select="concat(substring(StartDate,6,2),'/',substring(StartDate,9,2),'/',substring(StartDate,1,4))"/>

Jon

"There are 10 types of people in the world... those who understand binary and those who don't.