topic Re: Timestamp to Date format in QlikView

Timestamp to Date format

innashna — Fri, 15 Nov 2024 23:42:17 GMT

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

MayilVahanan — Mon, 02 Nov 2020 09:55:09 GMT

Try like below

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

innashna — Mon, 02 Nov 2020 10:19:16 GMT

Hi,

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

MayilVahanan — Mon, 02 Nov 2020 10:25:42 GMT

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

FYIP: