Hi,

I'm new to XSLT. I have to write a stylesheet to convert an xml to xhtml format.

The xml has some POSIX/UNIX times in it. I wonder whether there is any XSLT function which will convert a POSIX time value to a date/time value? POSIX is a fairly standard time format.

My value (5881113510280167424) is a 64 bit number - a seconds/nanoseconds pair. It's possible to work out the date if I use some bit manipulation (get the number of seconds and then work out the year, month, day, etc).

Are there any XSLT math operators that will do LEFT/RIGHT SHIFT? What about bitwise AND?

Multiply your number by something like xs:dayTimeDuration('PT1S') to get a duration in seconds, then add the magic dateTime('1970-01-01T00:00:00Z') to get the corresponding date/time.

__________________
Michael Kay
http://www.saxonica.com/
Author, XSLT 2.0 and XPath 2.0 Programmer\'s Reference

Thanks for your response. However, when I multiply my number with xs:dayTimeDuration('PT1S') I get an overflow error. The result must be greater than 64 bits.

If your number is in nanoseconds rather than seconds, then divide it by 10^9 first. However, limits on range and precision for durations depend on the processor you are using.

__________________
Michael Kay
http://www.saxonica.com/
Author, XSLT 2.0 and XPath 2.0 Programmer\'s Reference

This is a POSIX number, so the top 32 bits represents the number of seconds since 1 Jan 1970 and the next 32 bits represent the nanoseconds part of the current second.

How do I get at the top 32 bits in XSLT? In C/C++ I do this: x >> 32 where x represents the number.

Just divide by 2^32.

__________________
Michael Kay
http://www.saxonica.com/
Author, XSLT 2.0 and XPath 2.0 Programmer\'s Reference