Qlik Community

Ask a Question

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Welcome to our newly redesigned Qlik Community! Read our blog to learn about all the new updates: READ BLOG and REPORTED ISSUES
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