Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
fmcrashid
Contributor II
Contributor II

How to convert UTC integer to EST?

Hi Experts

need help in converting UTC integer to EST time.

e.g. 1636888080000  is Nov 14 06:08 AM

Labels (1)
1 Solution

Accepted Solutions
Øystein_Kolsrud
Employee
Employee

I think something like this should work:

Timestamp(ConvertToLocalTime(Makedate(1970,1,1),'GMT-05:00') + <input>/(1000*60*60*24))

View solution in original post

1 Reply
Øystein_Kolsrud
Employee
Employee

I think something like this should work:

Timestamp(ConvertToLocalTime(Makedate(1970,1,1),'GMT-05:00') + <input>/(1000*60*60*24))