
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
How to set up default TIMEZONE in Qlik
Hi,
Is there any way to setup a default time zone in QLik? currently in my DB all the time is in UTC and when I fetch the data from DB, I want that it should be automatically convert to 'Eastern Time (US & Canada)' zone?
in my DB the date is: 27-01-18 05:20:37.000000000 AM and when I save it in a QVD file it is showing as:- 27/1/2018 10:20:37 AM.
SO i think it is alreday converted to EST time zone by default. So please let me know if I am correct or not.
Thanks,
Sandip
Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi,
We need to use ConvertToLocalTIme() function to convert the date value from one time zone to another like below code:
converttolocaltime(Timestamp#('27-JAN-18 4.12.45.000000000 AM','DD-MMM-YY hh.mm.ss.ffffffffffff TT'), 'Eastern Time (US & Canada)',true())
and there is no way in Qlik to setup a time zone by default.
Thanks,
Sandip

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi,
Try using the Converttolocaltime() function.
Regards,
Kaushik Solanki

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi,
We need to use ConvertToLocalTIme() function to convert the date value from one time zone to another like below code:
converttolocaltime(Timestamp#('27-JAN-18 4.12.45.000000000 AM','DD-MMM-YY hh.mm.ss.ffffffffffff TT'), 'Eastern Time (US & Canada)',true())
and there is no way in Qlik to setup a time zone by default.
Thanks,
Sandip
