xsl-list
[Top] [All Lists]

Re: [xsl] difference between an integer and current-dateTime()

2020-03-30 11:55:38
I posted that at the beginning of the thread within minutes of Martin's response:

https://www.biglist.com/lists/lists.mulberrytech.com/xsl-list/archives/202003/msg00084.html

At 2020-03-30 13:21 +0000, Dimitre Novatchev dnovatchev(_at_)gmail(_dot_)com 
wrote:
So you really missed this simple solution:Â <https://stackoverflow.com/a/3468123/36305>https://stackoverflow.com/a/3468123/36305


 ( current-dateTime() - xs:dateTime('1970-01-01T00:00:00') )
 div
   xs:dayTimeDuration('PT1S')

On Mon, Mar 30, 2020 at 4:51 AM Mukul Gandhi <mailto:gandhi(_dot_)mukul(_at_)gmail(_dot_)com>gandhi(_dot_)mukul(_at_)gmail(_dot_)com <<mailto:xsl-list-service(_at_)lists(_dot_)mulberrytech(_dot_)com>xsl-list-service(_at_)lists(_dot_)mulberrytech(_dot_)com> wrote: On Mon, Mar 30, 2020 at 12:23 PM Martin Honnen <mailto:martin(_dot_)honnen(_at_)gmx(_dot_)de>martin(_dot_)honnen(_at_)gmx(_dot_)de <<mailto:xsl-list-service(_at_)lists(_dot_)mulberrytech(_dot_)com>xsl-list-service(_at_)lists(_dot_)mulberrytech(_dot_)com> wrote: Am 30.03.2020 um 08:49 schrieb Mukul Gandhi <mailto:gandhi(_dot_)mukul(_at_)gmail(_dot_)com>gandhi(_dot_)mukul(_at_)gmail(_dot_)com:

Â
Here you have used the wrong prefix "xs" again, instead you want
     <xsl:sequence select="$totalSecs"/>
no?


The following finally works for me,

<xsl:stylesheet xmlns:xsl="<http://www.w3.org/1999/XSL/Transform>http://www.w3.org/1999/XSL/Transform"; Â Â Â Â Â Â Â Â Â Â Â Â Â xmlns:xs="<http://www.w3.org/2001/XMLSchema>http://www.w3.org/2001/XMLSchema";
                         xmlns:fn0="<http://fns0>http://fns0";
                         exclude-result-prefixes="xs fn0"
                         version="3.0">
              Â
    <xsl:output method="text"/>               Â
              Â
  <xsl:param name="secsSinceEpoch" as="xs:integer"/>        Â
  Â
    <xsl:template match="/">
    <xsl:variable name="epochDateTime" select="xs:dateTime('1970-01-01T00:00:00Z') +                                          xs:dayTimeDuration('PT' || $secsSinceEpoch || 'S')"                      as="xs:dateTime"/>     <xsl:variable name="diffDTduration" select="current-dateTime() - $epochDateTime" as="xs:dayTimeDuration"/>     <xsl:value-of select="fn0:minsFromdiffDTduration($diffDTduration)"/>
    </xsl:template>
  Â
    <xsl:function name="fn0:minsFromdiffDTduration" as="xs:decimal">
       <xsl:param name="diffDTduration" as="xs:dayTimeDuration"/>
      Â
    <xsl:variable name="yrsDuration" select="years-from-duration($diffDTduration)"/>     <xsl:variable name="mnthsDuration" select="months-from-duration($diffDTduration)"/>     <xsl:variable name="daysDuration" select="days-from-duration($diffDTduration)"/>     <xsl:variable name="hrsDuration" select="hours-from-duration($diffDTduration)"/>     <xsl:variable name="mnsDuration" select="minutes-from-duration($diffDTduration)"/>     <xsl:variable name="secsDuration" select="seconds-from-duration($diffDTduration)"/>
      Â
    <xsl:variable name="totalSecs" select="$yrsDuration * 365 * 24 * 60 + $mnthsDuration * 30 * 24 * 60 +                                    $daysDuration * 24 * 60 + $hrsDuration * 60 + $mnsDuration +                                    $secsDuration div 60" />
       <xsl:sequence select="$totalSecs"/>
  Â
    </xsl:function>
  Â
</xsl:stylesheet>

Many thanks.


--
Regards,
Mukul Gandhi
<http://www.mulberrytech.com/xsl/xsl-list>XSL-List info and archive
<http://lists.mulberrytech.com/unsub/xsl-list/782854>EasyUnsubscribe (by email)



--
Cheers,
Dimitre Novatchev
---------------------------------------
Truly great madness cannot be achieved without significant intelligence.
---------------------------------------
To invent, you need a good imagination and a pile of junk
-------------------------------------
Never fight an inanimate object
-------------------------------------
To avoid situations in which you might make mistakes may be the
biggest mistake of all
------------------------------------
Quality means doing it right when no one is looking.
-------------------------------------
You've achieved success in your field when you don't know whether what you're doing is work or play
-------------------------------------
To achieve the impossible dream, try going to sleep.
-------------------------------------
Facts do not cease to exist because they are ignored.
-------------------------------------
Typing monkeys will write all Shakespeare's works in 200yrs.Will they write all patents, too? :)
-------------------------------------
Sanity is madness put to good use.
-------------------------------------
I finally figured out the only reason to be alive is to enjoy it.
Â
<http://www.mulberrytech.com/xsl/xsl-list>XSL-List info and archive
<http://lists.mulberrytech.com/unsub/xsl-list/96802>EasyUnsubscribe (<>by email)


--
Contact info, blog, articles, etc. http://www.CraneSoftwrights.com/s/ |
Check our site for free XML, XSLT, XSL-FO and UBL developer resources |
Streaming hands-on XSLT/XPath 2 training class @ US$45 (5 hours free) |
Essays (UBL, XML, etc.) http://www.linkedin.com/today/author/gkholman |
--~----------------------------------------------------------------
XSL-List info and archive: http://www.mulberrytech.com/xsl/xsl-list
EasyUnsubscribe: http://lists.mulberrytech.com/unsub/xsl-list/1167547
or by email: xsl-list-unsub(_at_)lists(_dot_)mulberrytech(_dot_)com
--~--

<Prev in Thread] Current Thread [Next in Thread>