Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
LINKEDIN LIVE: Democratizing data to enhance customer-centricity. JULY 29TH REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
jeremyjinks
Partner
Partner

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
Partner

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
Champion
Champion