Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
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.
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
see this: