[XSL-LIST Mailing List Archive Home] [By Thread] [By Date]

Re: [xsl] calculate UTC


Subject: Re: [xsl] calculate UTC
From: henry human <henry_human@xxxxxxxx>
Date: Sun, 24 Jun 2012 17:35:30 +0100 (BST)

thanks, I need only the difference and your script bello helps:
<xsl:value-of
select="timezone-from-dateTime(xsd:dateTime(concat(MSG/DTE,'T',TME)))-
implicit-timezone()"/>
But the result must be only the difference in hhmm format.
result sample: 0212
?


--- G. Ken Holman <gkholman@xxxxxxxxxxxxxxxxxxxx> schrieb am So, 24.6.2012:

> Von: G. Ken Holman <gkholman@xxxxxxxxxxxxxxxxxxxx>
> Betreff: Re: [xsl] calculate UTC
> An: xsl-list@xxxxxxxxxxxxxxxxxxxxxx, "xslforum xslforum"
<xsl-list@xxxxxxxxxxxxxxxxxxxxxx>
> Datum: Sonntag, 24. Juni, 2012 17:24 Uhr
> At 2012-06-24 15:53 +0100, henry
> human wrote:
> > I have following element, TIME as bellow and want to
> calculate the UTC time difference
> > between that time and the local time (local time Hong
> Kong)
> > <STSF>
> > <DTE>2012-06-14</DTE>
> > <TME>06:20:00.0Z</TME>
> > </STSF>
>
> Again, I'm guessing here ... not sure if you want just the
> time difference between time zones, or if you want the given
> UTC time in your local time.
>
> I'm executing this test in Atlantic Daylight Savings Time
> (UTC - 03:00), so I'm getting the results for my local
> time.  If your machine's time zone is set to Hong Kong
> time, then you'll get the results for your time zone.
>
> I hope this helps.
>
> . . . . . . . . .  Ken
>
> ~/t/ftemp $ cat henry2.xml
> <?xml version="1.0" encoding="UTF-8"?>
> <STSF>
> <DTE>2012-06-14</DTE>
> <TME>06:20:00.0Z</TME>
> </STSF>
> ~/t/ftemp $ xslt2 henry2.xml henry2.xsl
> <?xml version="1.0" encoding="UTF-8"?>
> Local time zone: -PT3H
> Time zone difference: PT3H
> File time in local time: 2012-06-14T03:20:00-03:00
> ~/t/ftemp $ cat henry2.xsl
> <?xml version="1.0"?>
> <xsl:stylesheet xmlns:xsl="http://www.w3.org/1999/XSL/Transform"
>   exclude-result-prefixes="xsd"
>   xmlns:xsd="http://www.w3.org/2001/XMLSchema"
>   version="2.0">
>
> <xsl:output indent="yes"/>
>
> <xsl:template match="STSF">
> Local time zone: <xsl:value-of
> select="implicit-timezone()"/>
> Time zone difference: <xsl:value-of
>    
> select="timezone-from-dateTime(xsd:dateTime(concat(DTE,'T',TME)))
>             -
> implicit-timezone()"/>
> File time in local time: <xsl:value-of
>                
>          
> select="adjust-dateTime-to-timezone(
>                
>                
>   xsd:dateTime(concat(DTE,'T',TME)),
>                
>                
>   implicit-timezone())"/>
>   <xsl:text>&#xa;</xsl:text>
> </xsl:template>
>
> </xsl:stylesheet>
> ~/t/ftemp $
>
>
> --
> Public XSLT, XSL-FO, UBL and code list classes in Europe --
> Oct 2012
> Contact us for world-wide XML consulting and instructor-led
> training
> Free 5-hour lecture: http://www.CraneSoftwrights.com/links/udemy.htm
> Crane Softwrights Ltd.         
>   http://www.CraneSoftwrights.com/s/
> G. Ken Holman           
>        mailto:gkholman@xxxxxxxxxxxxxxxxxxxx
> Google+ profile: https://plus.google.com/116832879756988317389/about
> Legal business disclaimers:    http://www.CraneSoftwrights.com/legal


Current Thread
Keywords