Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
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