Conversion of Timestamp into Millis

rameshnishi · November 23rd, 2006, 03:10 AM

Hi,

could any provide me with the XSLT 2.0 code which converts the system TIMESTAMP into Milliseconds
thanks in advance

regards,
ramesh

joefawcett · November 23rd, 2006, 04:49 AM

Not sure what you mean but I would think that you'd use substring, substring-before etc. If that's not enough show how a TIMESTAMP is represented and which part is the milliseconds.

--

Joe (Microsoft MVP - XML)

mhkay · November 23rd, 2006, 05:30 AM

(current-dateTime() - dateTime('1900-01-01T00:00:00') (:or whatever baseline you want to use :) ) div xs:dayTimeDuration('PT0.001S')

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

ramesh.kumarm · November 23rd, 2006, 05:44 AM

A Timestamp would rather be something like what Michael has shown
'1900-01-01T00:00:00' - Still it can contain Milliseconds at the end too.

So just strip off the string-after T and have a logic to show/calculate the hh:mm:ss:SS to SS [where SS is the denotion for Milliseconds]