How to convert Date time from PST to CST ?

[#1]

Hi ,

How to convert Date time from PST to CST ?

Ex: 2009-12-20 14:27:42  to CST.

[Anonymous]

Hi

try this

timestamp(MyDate + NumberOfHours/24)

or

timestamp(MyDate +2/24)  (Central Time is 2 hours ahead of Pacific Time)

[danansell42]

Hi you could use the convertolocaltime function

Please see below for link to qlik help

https://help.qlik.com/en-US/qlikview/12.0/Subsystems/Client/Content/Scripting/DateAndTimeFunctions/c...

[danansell42]

Hi

Did either of the responses solve your query?

Please mark one as correct to help other community users.

Thanks

Dan

[Anil_Babu_Samineni]

=timestamp(ConvertToLocalTime(PST(), 'UTC - 6'),'DD-MM-YYYY HH:MM:SS:FF TT') // Try what ever you want