Skip to main content
Announcements
Qlik Connect 2025! Join us in Orlando join us for 3 days of immersive learning: REGISTER TODAY

How to convert Epoch Unix Timestamp 1668080702447 MM/DD/YYYY

67% helpful (2/3)
cancel
Showing results for 
Search instead for 
Did you mean: 
Bill_Britt
Former Employee

How to convert Epoch Unix Timestamp 1668080702447 MM/DD/YYYY

Last Update:

Nov 11, 2024 4:26:07 AM

Updated By:

Sonja_Bauernfeind

Created date:

Nov 10, 2022 9:13:27 AM

You can find information on how to covert the Epoch Unix timestamp on: https://www.unixtimestamp.com/

The unix time stamp is a way to track time as a running total of seconds. This count starts at the Unix Epoch on January 1st, 1970 at UTC. Therefore, the unix time stamp is merely the number of seconds between a particular date and the Unix Epoch. 

To convert it to date and time you will need to use the following syntax:

timeStamp(Makedate(1970,1,1)+ 1668085945 /24/60/60 + Date((120/24/60) , 'YYYY-MM-DD hh:mm:ss'))

The number 1668085945 is your timestamp. Replace it with the timestamp you wish to convert.

Labels (1)
Comments
QFabian
Specialist III

Thanks @Bill_Britt and  @Sonja_Bauernfeind 

works perfectly