>> 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