Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Search instead for
Did you mean:
Discussion board for questions about the Qlik Community, its features, sharing information, general discussions and even some fun. This is for both new and longtime community members. Everyone is welcome!
Human_Time: Load CRNO, Endtime as Epoch, Timestamp(RangeSum('01/01/1970',Starttime/86400)) as Starttime, Timestamp(RangeSum('01/01/1970',Endtime/86400)) as Endtime, CI Resident Epoch;
Drop Table Epoch;
Above I'm converting Epoch to Timestamp. Epoch/86400 results in number of days. I did use 01/01/1970 considering the epoch definition (The Unix epoch (or Unix time or POSIX time or Unix timestamp) is the number of seconds that have elapsed since January 1, 1970 (midnight UTC/GMT), not counting leap seconds (in ISO 8601: 1970-01-01T00:00:00Z). Literally speaking the epoch is Unix time 0 (midnight 1/1/1970), but 'epoch' is often used as a synonym for 'Unix time'. Many Unix systems store epoch dates as a signed 32-bit integer, which might cause problems on January 19, 2038 (known as the Year 2038 problem or Y2038). ).