Qlik Community

Ask a Question

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Qlik Highlights 2020 Giveaway! Watch, reply and have a chance to win a $200 Amazon Gift Card! Watch Video
cancel
Showing results for 
Search instead for 
Did you mean: 
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

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

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
Contributor II
Contributor II

Hi,

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

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