How to display the time zone

[jeremyjinks]

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

[hemhund2016]

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.

[jagan]

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]

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

[Anonymous]

see this:

Date conversion w/ timezone