Re: [xsl] sorting date prob

Subject: Re: [xsl] sorting date prob
From: Jarkko.Moilanen@xxxxxx
Date: Thu, 11 Apr 2002 10:12:26 +0300 (EEST)
Yes. It is correct to be in the format yymmdd, because that is the ISO 
standard. And yes, everyone does not care about standards, but I have to.
So I will chance the format in the database, since it is possible 
for us at the moment. 

> Hello Jarkko,
> 
> you must bring the date to the format yyyymmdd. The best to do this is
> in
> the XML, because the date-formatting is a style-question, so it should
> be
> done in the stylesheet. If this is not possible, you can do it
> temporarily
> in the stylesheet too:
> 
> <xsl:sort select="concat(substring(Time,7,2), substring(Time,4,2),
> substring(1,2))"/>

Yes, thank U. If it was not possible for us to chance the format in DB, this 
would be a marvelous solution. 

> 
> Regards,
> 
> Joerg
> 
> > Hi!
> >
> > First things first. Thanks a lot Jeni for your advices about
> > selecting attribute for link value.
> >
> > Then another question:
> > I should sort the xml file ascending by the given date.
> > The xml syntax is like this:
> >
> > <Information>
> >     <Time>06/04/02</Time> #format is dd/mm/yy
> >     <Size>299</Size>
> >     <Sender>Moilanen Jarkko</Sender>
> >     <Subject id="00223322334342">Xalan</Subject>
> > </Information>
> >
> > <Information>
> >     <Time>05/11/02</Time>
> >     <Size>45</Size>
> >     <Sender>Moilanen Jarkko</Sender>
> >     <Subject id="00223322342334342">Atribuutit linkkeina</Subject>
> > </Information>
> >
> > If I try to sort them by xsl:
> > <xsl:sort order="ascending" select="Time" />
> >
> > the result is not the correct one.Is there some solution to this,
> > or should the xml file be different concerning the syntax?
> 
> 
>  XSL-List info and archive:  http://www.mulberrytech.com/xsl/xsl-list
> 
> 



*******************************************************************
Jarkko Moilanen         *You are wise, witty, and wonderful,      *
Research/ ITCM          *but you spend too much time              *
jarkko.moilanen@xxxxxx  *reading this sort of trash.              *
www.uta.fi/~jm60697     *                                         *
GSM: +358 50 3766 927   *                                         *
*******************************************************************

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


Current Thread