Re: [xsl] Date format

Cart

XML Editor - Download a Free Trial >

See What's New >

Buy Now >

[Home] [By Thread] [By Date] [Recent Entries]

Subject: Re: Date format
From: Rick Taylor <taylor@xxxxxxxx>
Date: Fri, 22 Aug 2003 12:09:13 -0600

Depending on what database you have and how you are extracting the data into XML, you could format the date when you query the database. Alternatively, you could extract just the portion you need form the XML "YYYY-MM-DD" by modifying your select to:

<xsl:value-of select="substring-before(the_date, ' ')"/>

rick

At 07:07 PM 8/22/03 +0200, you wrote:

hello from one database i get the date format with this:
<xsl:value-of select="the_date"/> (the_date is the field nakme in the xml
tree)
 and appears in this format:  2003-08-22 18:32:05
but i want to writte int this format: 2003-08-23
how can i make it?
can you help me? thanks
XSL-List info and archive: http://www.mulberrytech.com/xsl/xsl-list


Rick Taylor
XML Developer
PPDM Association

XSL-List info and archive: http://www.mulberrytech.com/xsl/xsl-list

Current Thread
Date format Dionisio Ruiz de Zarate - Fri, 22 Aug 2003 13:23:44 -0400 (EDT) Rick Taylor - Fri, 22 Aug 2003 14:11:58 -0400 (EDT) <= <Possible follow-ups> Chang, Shining - Fri, 22 Aug 2003 13:51:35 -0400 (EDT)

<- Previous	Index	Next ->
Date format, Dionisio Ruiz de Zar	Thread	RE: Date format, Chang, Shining
RE: AW: exclude result prefix, Michael Kay	Date	Re: exclude result prefixes d, Mark R. Diggory
	Month

XML Editor - Download a 15 Day Free Trial Now >

See What's New in Stylus Studio >

Buy Stylus Studio - XML Editor - Now >