Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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
Partner - Champion III
Partner - Champion III

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
Partner - Champion III
Partner - Champion III

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