[XSL-LIST Mailing List Archive Home] [By Thread] [By Date] [Recent Entries] [Reply To This Message]

RE: Date format

Subject: RE: Date format
From: AXRAMAKR@xxxxxx
Date: Thu, 30 May 2002 10:08:45 -0500
convertrtdate
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@xxxxxxxxxxxx>           To:       <xsl-list@xxxxxxxxxxxxxxxxxxxxxx>            
                      Sent by:                          cc:                                                    
                      owner-xsl-list@xxxxxxxxxxx        Subject:  RE:  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


Current Thread
  • Date format
    • AXRAMAKR - Thu, 30 May 2002 08:49:53 -0400 (EDT)
      • <Possible follow-ups>
      • gary cor - Thu, 30 May 2002 09:27:53 -0400 (EDT)
      • AXRAMAKR - Thu, 30 May 2002 11:18:33 -0400 (EDT) <=
        • Ali Mutlu - Thu, 30 May 2002 11:55:38 -0400 (EDT)
      • AXRAMAKR - Thu, 30 May 2002 12:36:30 -0400 (EDT)

PURCHASE STYLUS STUDIO ONLINE TODAY!

Purchasing Stylus Studio from our online shop is Easy, Secure and Value Priced!

Buy Stylus Studio Now

Download The World's Best XML IDE!

Accelerate XML development with our award-winning XML IDE - Download a free trial today!

Don't miss another message! Subscribe to this list today.
Email
First Name
Last Name
Company
Subscribe in XML format
RSS 2.0
Atom 0.3
Site Map | Privacy Policy | Terms of Use | Trademarks
Free Stylus Studio XML Training:
W3C Member
Stylus Studio® and DataDirect XQuery ™are products from DataDirect Technologies, is a registered trademark of Progress Software Corporation, in the U.S. and other countries. © 2004-2013 All Rights Reserved.