[XSL-LIST Mailing List Archive Home] [By Thread] [By Date] [Recent Entries] [Reply To This Message] Re: DateTime Conversion question
At 2010-10-06 23:50 +0100, Neil Owens wrote:
I'm trying to convert a (UK) date format into a SQL DateTime so I can ingest the resultant transform into SQL2008 with SSIS That looks suspiciously like ISO 8601 date format: 2010-10-06T22:22:01+01:00 I'm happy to use XSLT 1.0 or 2.0, however, everything I've read today says that .NET2008 only supports XSLT 1.0, as I'm using System.Xml.Xsl.XslCompiledTransform to 'do' the transformation Repetitive use of substring() would work in XSLT 1: <xsl:value-of select="concat( substring(@Time,7,4),'-',substring(@Time,4,2),'-',substring(@Time,1,2),'T', substring(@Time,12,8),'+01:00' )"/> If you want to reduce the typing a bit: <xsl:for-each select="@Time"> <xsl:value-of select="concat( substring(.,7,4),'-',substring(.,4,2),'-',substring(.,1,2),'T', substring(.,12,8),'+01:00' )"/> </xsl:for-each> In XSLT 2 I might use regex and groups to pull apart the string. I hope this helps. . . . . . . . . Ken
|
PURCHASE STYLUS STUDIO ONLINE TODAY!Purchasing Stylus Studio from our online shop is Easy, Secure and Value Priced! Download The World's Best XML IDE!Accelerate XML development with our award-winning XML IDE - Download a free trial today! Subscribe in XML format
|