Re: [xsl] format-dateTime() - using the picture to adjust t

Cart

XML Editor - Download a Free Trial >

See What's New >

Buy Now >

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

Subject: Re: format-dateTime() - using the picture to adjust timezones
From: Martin Honnen <Martin.Honnen@xxxxxx>
Date: Tue, 08 Sep 2009 15:56:51 +0200

tom tom wrote:

Is there a way to use the Date - Time Picture used as the second argument in the format-dateTime() (or similar) function so that when it processes the following date:

2009-09-08T07:35:17+08:00

the month, day and year can all be rendered in UTC. The above example refers to 2009-09-07UTC. All my attempts to adjust '[D]' to render as UTC instead of +08:00 have failed.

"adjust" is the right keyword, I think what you want to use is not a particular picture string for the format functions but rather the function adjust-dateTime-to-timezone e.g.

adjust-dateTime-to-timezone(xs:dateTime('2009-09-08T07:35:17+08:00'), xs:dayTimeDuration('PT0H'))

should adjust the dateTime to the UTC meaning you get 2009-09-07T23:35:17Z.

The you can use format-dateTime on the adjusted dateTime value.

--

	Martin Honnen
	http://msmvps.com/blogs/martin_honnen/

Current Thread
format-dateTime() - using the picture to adjust timezones tom tom - 8 Sep 2009 11:48:34 -0000 Martin Honnen - 8 Sep 2009 13:57:17 -0000 <= tom tom - 8 Sep 2009 15:38:35 -0000

<- Previous	Index	Next ->
format-dateTime() - using the, tom tom	Thread	RE: format-dateTime() - using, tom tom
format-dateTime() - using the, tom tom	Date	RE: format-dateTime() - using, tom tom
	Month

XML Editor - Download a 15 Day Free Trial Now >

See What's New in Stylus Studio >

Buy Stylus Studio - XML Editor - Now >