Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
May 18th 10AM ET, Live Chat, bring your QlikView questions. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
innashna
Contributor II
Contributor II

Timestamp to Date format

Hi,

I have the following timestamp format:

1604303491916

 

I need to convert it to : 'YYYY-MM-DD HH:MM:SS'.

I used the following formula:

date(([timeStamp]/24/60/60/1000 )+ 25569,'YYYY-MM-DD HH:MM:SS')

 

It gives incorrect hour.

It should be:

2020-11-02 09:51:32

But my formula gives to me:

2020-11-01 07:11:55.

Can you please help me?

Thanks,

Inna

Labels (1)
1 Solution

Accepted Solutions
MayilVahanan

Hi @innashna 

Yes, its might be relates to timezone. You can convert via ConvertToLocalTime()

FYIP:

MayilVahanan_0-1604312659352.png

 

Thanks & Regards,
Mayil Vahanan R

View solution in original post

3 Replies
MayilVahanan

Hi @innashna 

Try like below

=date((1604303491916/24/60/60/1000 )+ 25569,'YYYY-MM-DD HH:mm:SS')
Minute must be in "mm" not "MM"

 

Thanks & Regards,
Mayil Vahanan R
innashna
Contributor II
Contributor II
Author

Hi,

the  minutes are correct now. But hour still shows 07 and not 09. It relates to timezone, right?

MayilVahanan

Hi @innashna 

Yes, its might be relates to timezone. You can convert via ConvertToLocalTime()

FYIP:

MayilVahanan_0-1604312659352.png

 

Thanks & Regards,
Mayil Vahanan R

View solution in original post