Skip to main content
Announcements
Qlik Community Office Hours, March 20th. Former Talend Community users, ask your questions live. SIGN UP
cancel
Showing results for 
Search instead for 
Did you mean: 
jeremyjinks
Partner - Contributor
Partner - 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
Creator
Creator

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
Luminary Alumni
Luminary Alumni

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
Partner - Specialist
Partner - Specialist

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
Not applicable