Change looker Default time zone to EST

guneev09
Participant I

Hi,

I am looking to add a filter on date: Idea is to get real time orders from order table  (local time is EST)

My column is a date column in EST time zone whereas looker is in UTC. Is it possible to convert  looker default time zone to EST since I want in EST 

0 12 1,528
12 REPLIES 12

Do you see an option in the top right of your explore (next to Run button) to select a timezone? 

08423257-1787-44d9-b4a0-d8e41fd0205b.png

If so, you can change it to EST there.  If not, you can ask your Looker Admin to review these timezone options and determine which settings are best for your company. If you have multiple users in your company who need to see data for their own timezones, admin could enable User Specific Timezones and allow you to set your default timezone to EST (or you can use a dropdown to change the query timezone yourself as with the above example).

HI,
consider I enabled the user specific time zone and can I see the different time zone in the dropdown. when user select the time zone from the dropdown it changes the time zone to their selection and the requirement here is to  display the time zone of the changed time zone as a separate look in the looker dashboard .The above image is for the reference.

I have created a look for that using the field last refresh date/time from my database table.

For e.g: 2024-03-27 20:00:07 last refresh date/time  which is in America -new York timezone.

 When I select timezone from the drop down to US-alaska timezone and it is showing like this 2024-03-27 16:00:07 .

Now the req is to display the time zone  like this  “2024-03-27 16:00:07 US-Alaska’’.

can anyone reply for this.

guneev09
Participant I

Hi Jennifer,

Thank you for reaching out. Is this option also applies to looker explore filters for ex. today will be in EST time?

Yes, we have hundreds of users using looker explores but I am looking for looker filter to be applied in EST time zone for my explore

I have a filter on order Date (which is in EST) and I want to filter it by an advanced filter set to “TODAY” option. right now, the issue is today brings in UTC date . I want it to be in EST in my explore

Can you share more details on how to set this at an explore level?

Dawid
Participant V

If you enable the Timezone offset in settings then all your fields will be offset as well unless you stop it by adding a parameter convert_tz: no

guneev09
Participant I

Hi Dawid,

Is it possible to set timezone at an explore level? so that filters show date in EST?

Dawid
Participant V

Hi, I don’t believe it’s possible. What do you mean filters show date in EST? Filters are abstract like “last 2 days”, it’s only in the underlaying SQL where the offsetting takes place. Anyway you can only set time zone globally and then allow users to change it in their own settings if need be, not possible in the codebase layer

guneev09
Participant I

Yes, but today/yesterday in advanced filters are in UTC right now. I am looking for EST timezone for an explore since my data source for the explore is in EST

Dawid
Participant V

I just checked one of my dimensions. I do have Europe/Madrid time zone switched on:

44944444-c17b-432c-ac7b-c6ac2948a59b.png
6a827079-90b8-40b3-a5cc-ac5ee83be655.png

It looks like even with advanced filters the time zone is applied

guneev09
Participant I

Yes, for me this advanced filter shows in UTC timezone whereas I am looking for EST

Dawid
Participant V
fc2bf836-7ab2-462b-9ef9-28c2ba90e20b.png

Admin → Settings

And then in your connection Settings

8d8d2456-3d21-4d78-84bd-1fdd8a1ab8a7.png

guneev09
Participant I

Got it. Thank for sharing this. I guess this is limited to data base right.

HI,
consider I enabled the user specific time zone and can I see the different time zone in the dropdown. when user select the time zone from the dropdown it changes the time zone to their selection and the requirement here is to  display the time zone of the changed time zone as a separate look in the looker dashboard .The above image is for the reference.

I have created a look for that using the field last refresh date/time from my database table.

For e.g: 2024-03-27 20:00:07 last refresh date/time  which is in America -new York timezone.

 When I select timezone from the drop down to US-alaska timezone and it is showing like this 2024-03-27 16:00:07 .

Now the req is to display the time zone  like this  “2024-03-27 16:00:07 US-Alaska’’.

can anyone reply for this.

Top Labels in this Space
Top Solution Authors