xsl-list
[Top] [All Lists]

Re: [xsl] dateTime conversion

2010-10-03 18:35:34
Michael,

I am using xslt 1.0. I guess I need to find more from requirements. 

My xsd has xs:datetime variable but I am receiving "2010-10-03T18:15:20-0400" 
from my client and hence the validation is failing.  In xmlspy, if I auto 
generate the xml from xsd, sample value for xs:datetime is in format 
"2001-12-17T09:30:47Z". So I thought I might have to convert 
"2010-10-03T18:15:20-0400" to format "2001-12-17T09:30:47Z". 

But the number in the TO format is just a sample. I am not sure what is the 
efficient way to convert date that is in format "2010-10-03T18:15:20-0400" to 
format "2001-12-17T09:30:47Z"


--- On Sun, 10/3/10, Michael Kay <mike(_at_)saxonica(_dot_)com> wrote:

From: Michael Kay <mike(_at_)saxonica(_dot_)com>
Subject: Re: [xsl] dateTime conversion
To: xsl-list(_at_)lists(_dot_)mulberrytech(_dot_)com
Date: Sunday, October 3, 2010, 7:07 PM

Please ignore the portion that is before the timezone
and convert
T18:15:20-0400 to T09:30:47Z

Numbers are just the samples. But if I take a closure
look at them, -0400 needs to be replaced with "Z"


Do you want to convert 12:00:00-04:00 to 08:00:00Z (the
same time instant in a different time zone) or to
12:00:00Z?

And are you using XSLT 1.0 or 2.0?

Note: your date-time values are almost in ISO 8601 format,
except for the missing colon between hours and minutes in
the timezone offset. Was this difference deliberate?

Michael Kay
Saxonica

--~------------------------------------------------------------------
XSL-List info and archive:  http://www.mulberrytech.com/xsl/xsl-list
To unsubscribe, go to: http://lists.mulberrytech.com/xsl-list/
or e-mail: 
<mailto:xsl-list-unsubscribe(_at_)lists(_dot_)mulberrytech(_dot_)com>
--~--




      

--~------------------------------------------------------------------
XSL-List info and archive:  http://www.mulberrytech.com/xsl/xsl-list
To unsubscribe, go to: http://lists.mulberrytech.com/xsl-list/
or e-mail: <mailto:xsl-list-unsubscribe(_at_)lists(_dot_)mulberrytech(_dot_)com>
--~--

<Prev in Thread] Current Thread [Next in Thread>