Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

jeremyjinks
New Contributor

How to display the time zone

How in qlik sense can I display the time zone offset for a timestamp?

So for Jan. 1, 2015 8:00 AM CST I would like to see: 1-1-2015 08:00:00:-06:00

4 Replies
hemhund2016
Contributor

Re: How to display the time zone

May not be a good solution.

Can you try this?

ConvertToLocalTime(Mydate,'Central Time (US & Canada)') & ':'& if(right(text(Mydate),3)='CST','-06:00')


Thanks,

Hemanth.

MVP
MVP

Re: How to display the time zone

HI,

Try like this

=TimeStamp(Now() - 6/24)

OR

=TimeStamp(TimeExpression - 6/24)

Note: 6/24 means 6 hours

Hope this helps you

Regards,

Jagan.

eduardo_sommer
Valued Contributor

Re: How to display the time zone

Hi, Jeremy

If you want the time zone only, use the function =TimeZone()

If you want the localtime along with the time zone, use =LocalTime()&TimeZone()

I hope that this helps you

Regards

Eduardo

balrajahlawat
Esteemed Contributor

Re: How to display the time zone

Community Browser