Forum Discussion

altus_nel's avatar
altus_nel
Contributor
10 years ago

start time node in Description.tcLog

Hi there,



Does anybody perhaps know how to convert the "start time" nodes' value (in the Description.tclog file) to a human readable form?



Currently it's something like:

<Prp name="start time" type="D" value="41983.5217424306"/>



It would be handy to know how this value is built up and how to convert it to something in the format of %Y%m%d%H%M



I've tried something like new Date().getTime() to get the currentTimeMillis but that does not have the desired effect (and is also completely different).



Thanks!

Altus



  • HKosova's avatar
    HKosova
    SmartBear Alumni (Retired)
    10 years ago
    Hi Altus,



    This is how aqDateTime's Date/Time values are represented internally.

    The integer part is the number of days passed since December 30, 1899.

    The fractional part is a fraction of a 24-hour period. Multiply it by 86400000 to convert the value to milliseconds.