Skip to main content

Qlik Community

cancel
Turn on suggestions
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: 

Official Support Articles

Search or browse our knowledge base to find answers to your questions ranging from account questions to troubleshooting error messages. The content is curated and updated by our global Support team

Announcements
Qlik Cloud Maintenance is scheduled between March 27-30. Visit Qlik Cloud Status page for more details.

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

cancel
Turn on suggestions
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: 
Bill_Britt
Support
Support
‎2022-11-10 09:13 AM

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

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'))

Labels (1)
Labels:
242 Views
Version history
Last update:
‎2022-11-10 09:25 AM
Updated by:
Digital Support