Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
jsnova
Partner - Contributor II
Partner - Contributor II

QvdCreateTime

the following code num(QvdCreateTime('$(vPath)'));

gives me 42515.580104167 as a timestamp back

while I was expecting something near:

1464177919

how comes? and how to solve this ?

1 Solution

Accepted Solutions
Gysbert_Wassenaar

What you expect is the number of seconds sinds 1-1-1970. What you get instead is the number of days since 30-12-1899. Now that you now what the values are you can figure out how to turn one format into another.

Like this I think: (QvdCreateTime('$(vPath)')) - MakeDate(1970)) * 86400


talk is cheap, supply exceeds demand

View solution in original post

1 Reply
Gysbert_Wassenaar

What you expect is the number of seconds sinds 1-1-1970. What you get instead is the number of days since 30-12-1899. Now that you now what the values are you can figure out how to turn one format into another.

Like this I think: (QvdCreateTime('$(vPath)')) - MakeDate(1970)) * 86400


talk is cheap, supply exceeds demand