This is the mail archive of the
xsl-list@mulberrytech.com
mailing list .
RE: Date format
- From: "Ali Mutlu" <alimutlu at 32bit dot com dot tr>
- To: <xsl-list at lists dot mulberrytech dot com>
- Date: Thu, 30 May 2002 19:56:11 +0300
- Subject: RE: [xsl] Date format
- Reply-to: xsl-list at lists dot mulberrytech dot com
Hi,
did you put
<xsl:text>20</xsl:text>
so the new template must be like
<xsl:template name="ConvertRtDate">
<xsl:param name="ADate"/>
<xsl:text>20</xsl:text>
<xsl:value-of select="substring($ADate,8,2)"/>
<xsl:choose>
....
or you can
<xsl:template name="ConvertRtDate">
<xsl:param name="ADate"/>
<xsl:value-of
select="concat('20',substring($ADate,8,2))"/>
<xsl:choose>
....
both has to work
rgds
Ali
-----Original Message-----
From: owner-xsl-list@lists.mulberrytech.com
[mailto:owner-xsl-list@lists.mulberrytech.com]On Behalf Of AXRAMAKR@UP.COM
Sent: Thursday, May 30, 2002 19:27
To: xsl-list@lists.mulberrytech.com
Cc: owner-xsl-list@lists.mulberrytech.com; xsl-list@lists.mulberrytech.com
Subject: RE: [xsl] Date format
Ali,
I'm sorry to bother you again...Changing it this way gives me 02 not 2002.
I guess my question is how to change 02 to 2002?
So the formatting of 17-MAY-02 should yield 20020517 not 020517.
Can we convert 2 digit year to 4 digit year?
Thanks,
Akila Ramakrishnan
(314) 768 5809
axramakr@up.com
"Ali Mutlu"
<alimutlu@32bit.com.tr> To:
<xsl-list@lists.mulberrytech.com>
Sent by: cc:
owner-xsl-list@lists.mulbe Subject: RE: [xsl]
Date format
rrytech.com
05/30/02 10:44 AM
Please respond to xsl-list
Akila,
replace the line
<xsl:value-of select="substring($ADate,8,4)"/>
with
<xsl:text>20</xsl:text>
<xsl:value-of select="substring($ADate,8,2)"/>
Rgds
Ali
-----Original Message-----
From: owner-xsl-list@lists.mulberrytech.com
[mailto:owner-xsl-list@lists.mulberrytech.com]On Behalf Of AXRAMAKR@UP.COM
Sent: Thursday, May 30, 2002 18:09
To: xsl-list@lists.mulberrytech.com
Cc: owner-xsl-list@lists.mulberrytech.com; xsl-list@lists.mulberrytech.com
Subject: RE: [xsl] Date format
Ali,
Thanks for your help. However, when I call the template like this
<xsl:call-template name="ConvertRtDate">
<xsl:with-param name="ADate" select ="@trndte"/>
</xsl:call-template>
The date of 17-MAY-02 gets converted to 020517. How do I make it 20020517?
Thanks,
Akila
"Ali Mutlu"
<alimutlu@32bit.com.tr> To:
<xsl-list@lists.mulberrytech.com>
Sent by: cc:
owner-xsl-list@lists.mulbe Subject: RE: [xsl]
Date format
rrytech.com
05/30/02 08:15 AM
Please respond to xsl-list
>> I have a date 17-MAY-02 from the oracle database that I would like to
>> format as YYYYMMDDHR24MI and another date 117-MAY-02 to be converted to
>> YYYYMMDD.
>> I wish to do the transformation in the XSLT. Has anyone done this before
>> and if so how did you do it?
Akila,
The following template translates anything like dd-mmm-yyyy to yyyymmdd, I
beleive a shorter way may exists, but it works
Rgds
Ali
<xsl:template name="ConvertRtDate">
<xsl:param name="ADate"/>
<xsl:value-of select="substring($ADate,8,4)"/>
<xsl:choose>
<xsl:when test="substring($ADate,4,3)
='JAN'">
<xsl:value-of select
="'01'"/>
</xsl:when>
<xsl:when test="substring($ADate,4,3)
='FEB'">
<xsl:value-of select
="'02'"/>
</xsl:when>
<xsl:when test="substring($ADate,4,3)
='MAR'">
<xsl:value-of select
="'03'"/>
</xsl:when>
<xsl:when test="substring($ADate,4,3)
='APR'">
<xsl:value-of select
="'04'"/>
</xsl:when>
<xsl:when test="substring($ADate,4,3)
='MAY'">
<xsl:value-of select
="'05'"/>
</xsl:when>
<xsl:when test="substring($ADate,4,3)
='JUN'">
<xsl:value-of select
="'06'"/>
</xsl:when>
<xsl:when test="substring($ADate,4,3)
='JUL'">
<xsl:value-of select
="'07'"/>
</xsl:when>
<xsl:when test="substring($ADate,4,3)
='AUG'">
<xsl:value-of select
="'08'"/>
</xsl:when>
<xsl:when test="substring($ADate,4,3)
='SEP'">
<xsl:value-of select
="'09'"/>
</xsl:when>
<xsl:when test="substring($ADate,4,3)
='OCT'">
<xsl:value-of select
="'10'"/>
</xsl:when>
<xsl:when test="substring($ADate,4,3)
='NOV'">
<xsl:value-of select
="'11'"/>
</xsl:when>
<xsl:when test="substring($ADate,4,3)
='DEC'">
<xsl:value-of select
="'12'"/>
</xsl:when>
</xsl:choose>
<xsl:value-of select="substring($ADate,1,2)"/>
</xsl:template>
XSL-List info and archive: http://www.mulberrytech.com/xsl/xsl-list
XSL-List info and archive: http://www.mulberrytech.com/xsl/xsl-list
XSL-List info and archive: http://www.mulberrytech.com/xsl/xsl-list
XSL-List info and archive: http://www.mulberrytech.com/xsl/xsl-list
XSL-List info and archive: http://www.mulberrytech.com/xsl/xsl-list