? num2time(38741.3520833333300) Function Num2Time Lparameters tnFloat Return Dtot({^1899/12/30}+Int(m.tnFloat))+86400*(m.tnFloat-Int(m.tnFloat))For filetime:
DECLARE SHORT FileTimeToSystemTime IN Win32API; STRING @lpft, STRING @lpst DECLARE SHORT FileTimeToLocalFileTime IN Win32API; STRING @lpFileTime, STRING @lpLocalFileTime function _DecodeFileTime lparameters tcFileTime, tnMillis local lcLocalTime, lcSysTime, lnResult, ltTime ltTime = {/:} Store REPLICATE(CHR(0), 16) to lcLocalTime, lcSysTime if FileTimeToLocalFileTime(@tcfiletime, @lcLocalTime) # 0 and ; FileTimeToSystemTime(@lcLocalTime, @lcSysTime) # 0 ltTime = Datetime(Str2Val(substr(lcSysTime,1,2)), ; Str2Val(substr(lcSysTime, 3,2)),; Str2Val(substr(lcSysTime, 7,2)),; Str2Val(substr(lcSysTime, 9,2)),; Str2Val(substr(lcSysTime,11,2)),; Str2Val(substr(lcSysTime,13,2)) ) tnMillis = Str2Val(substr(lcSysTime,15,2)) endif Return ltTime Function Str2Val Lparameters tcStr Local lnVal lnVal = 0 for ix=1 to len(tcStr) lnVal = lnVal + asc(substr(tcStr,ix,1))*256^(ix-1) endfor return lnValCetin