PROCEDURE DecodeTimeStamp(nTimestamp as Number) as Datetime && see http://msdn.microsoft.com/library/default.asp?url=/library/en-us/sysinfo/base/filetimetodosdatetime.asp nDate=BITRSHIFT(nTimestamp,16) nTime=BITAND(nTimestamp,2^16-1) nYear=BITAND(BITRSHIFT(nDate,9),2^8-1)+1980 nMonth=BITAND(BITRSHIFT(nDate,5),2^4-1) nDay=BITAND(nDate,2^5-1) nHr=BITAND(BITRSHIFT(nTime,11),2^5-1) nMin=BITAND(BITRSHIFT(nTime,5),2^6-1) nSec=BITAND(nTime,2^5-1) RETURN DATETIME(nYear,nMonth,nDay,nHr,nMin,nSec) RETURN