Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

krishna20
Valued Contributor II

PST to GMT or UTC

Hi Folks,

I am having DB data which is logged in PST format and i need to convert into GMT or UTC with Daylight saving. 

Currently i am using Timestamp(ConvertToLocalTime(DateTime,'GMT+7:00'),True()) .

The above logic is not working as expected.

Could anyone advise on this topic??

 

Thanks & Regards

Krishna

1 Solution

Accepted Solutions
Support
Support

Re: PST to GMT or UTC

Check the Help, you have True for the ignore DST, you want False I believe! 🙂

https://help.qlik.com/en-US/qlikview/November2018/Subsystems/Client/Content/QV_QlikView/Scripting/Da...

Regards,
Brett

To help users find verified answers, please don't forget to use the "Accept as Solution" button on any posts that helped you resolve your problem or question.

View solution in original post

4 Replies
Somasundaram
Contributor III

Re: PST to GMT or UTC

krishna20
Valued Contributor II

Re: PST to GMT or UTC

Thanks for your reply. This logic is working only for without Daylight. With Daylight it's not working.

 

Highlighted
krishna20
Valued Contributor II

Re: PST to GMT or UTC

Does anyone faced this issue??
Support
Support

Re: PST to GMT or UTC

Check the Help, you have True for the ignore DST, you want False I believe! 🙂

https://help.qlik.com/en-US/qlikview/November2018/Subsystems/Client/Content/QV_QlikView/Scripting/Da...

Regards,
Brett

To help users find verified answers, please don't forget to use the "Accept as Solution" button on any posts that helped you resolve your problem or question.

View solution in original post