Converting Epoch timestamp to Normal timestamp (Date)

[deep2021]

Hi All,

i have epoch timestamp in the below format,

1669305600000

 166930560000

1669305600001

1669305600003

1669305600005

1669305600006

1669305600006

1669305600006

Can you please suggest how to convert epoch timestamp to our normal timestamp?

Thanks,

[kaushiknsolanki]

Check this post.

https://community.qlik.com/t5/App-Development/Exactly-How-Qlik-Sense-Convert-Epoch-Time/td-p/125896

[deep2021]

Hi,

Thanks for the reply,

But I am not getting the date in right format after doing this.

I used the below code,

T1:

load * Inline
[ timestart
1669305600000
1669305600001
1669305600001
1669305600003
1669305600005
1669305600006
1669305600006
1669305600006

];

[time]:

load
timestart,

date(floor(timestart/ 86400 + 25569)) as DateStart

Resident T1;

[MarcoWedel · Accepted solution]

I think your timestamps have millisecond resolution:

table1:
LOAD *,
     Date(Floor(timestart/86400000+25569))	as DateStart,
     Timestamp(timestart/86400000+25569,'MM/DD/YYYY hh:mm:ss.fff')	as DateTimeStart
Inline [
timestart
1669305600000
1669305600001
1669305600003
1669305600005
1669305600006
];