# HubDB Date and time timezone issue

**URL:** <https://community.hubspot.com/t/hubdb-date-and-time-timezone-issue/72756>\
**Category:** CMS Development\
**Tags:** hubdb, announcement\
**Created:** [January 12, 2023, 12:58pm UTC](https://community.hubspot.com/t/hubdb-date-and-time-timezone-issue/72756 "2023-01-12T12:58:30Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![tony\_newday](https://avatars.discourse-cdn.com/v4/letter/t/9e8a1a/32.png) [@tony\_newday](https://community.hubspot.com/u/tony_newday)\
**Post date:** [January 12, 2023, 12:58pm UTC](https://community.hubspot.com/t/hubdb-date-and-time-timezone-issue/72756/1 "2023-01-12T12:58:30Z")

</div>

Hi everyone!  
I need to add a column with date and time to my HubDB table. But the problem is that the data is displayed in UTC 00:00 time zone.  
At the same time, in my account defaults settings, I specified the time zone which I needed (EST -05:00)  
How can I make HubDB display the EST time zone initially?

 ![Снимок экрана 2023-01-12 в 14.53.52.jpg](https://d2qpr2jzcazej7.cloudfront.net/original/2X/5/5b5e3c9ba86d7b51fa17cae5151f6ec21d9b8ca4.jpeg)  
HubDB  
 ![Снимок экрана 2023-01-12 в 14.54.19.png](https://d2qpr2jzcazej7.cloudfront.net/original/3X/d/d/dd2f1f4d5ef58abe6df1bd614083e7cf521623f8.png)  
Account Default Setting

---

<div class="post-metadata">

**Author:** ![Jaycee\_Lewis](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/jaycee_lewis/32/61352_2.png) [@Jaycee\_Lewis](https://community.hubspot.com/u/Jaycee_Lewis)\
**Post date:** [January 12, 2023, 11:19pm UTC](https://community.hubspot.com/t/hubdb-date-and-time-timezone-issue/72756/2 "2023-01-12T23:19:31Z")

</div>

Hi, [@tony\_newday](https://community.hubspot.com/t5/user/viewprofilepage/user-id/494281) 👋 Thanks for reaching out! Hey, @BarryGrennan, do you have any thoughts here?

Best,

Jaycee

---

<div class="post-metadata">

**Author:** ![BarryGrennan](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/barrygrennan/32/97794_2.png) [@BarryGrennan](https://community.hubspot.com/u/BarryGrennan)\
**Post date:** [January 13, 2023, 7:37pm UTC](https://community.hubspot.com/t/hubdb-date-and-time-timezone-issue/72756/3 "2023-01-13T19:37:42Z")

</div>

The account defaults would have no bearing on HubDB event times, I think what you’d want to do is subtract the ammount of time in unix.

So if you’re outputting your event details like:

```lia-code-sample
{% for row in hubdb_table_rows(module.hubdbtable_field) %}
{{row.event_title}} starts at {{row.start_time|format_time('hh:mm a')}}<br>
{% endfor %}

```

change it to something like:

```lia-code-sample
{% for row in hubdb_table_rows(module.hubdbtable_field) %}
{{row.event_title}} starts at{{(row.start_time-(3600000 * 5))|format_time('hh:mm a')}}<br>
{% endfor %}

```

Edit: Although, now that I think about it, the question assumes that the person filling out the HubDB table is actually setting the UTC time of the event. What I mean is that in your screen shot where you have the event starting at 1pm {{row.start\_time|format\_time(‘hh:mm a’)}} would just print out 1pm, it’s not relevant if it’s 1pm UTC or EST -5

If I’m missing the mark here, please expand upon what you’re trying to achieve and why this is an issue.

* * *

 ![profile2022a.jpg](https://d2qpr2jzcazej7.cloudfront.net/original/2X/7/7273a34ccfe3489fceebc8a36eca751481b59531.jpeg)

**Barry Grennan**

[Freelance HubSpot CMS Developer](https://www.seoanseo.ca?utm_source=HubSpotCommunity)

[Website](https://www.seoanseo.ca?utm_source=HubSpotCommunity) | [Contact](https://www.seoanseo.ca/#contact?utm_source=HubSpotCommunity) | [LinkedIn](https://www.linkedin.com/in/barrygrennan)

---

<div class="post-metadata">

**Author:** ![tony\_newday](https://avatars.discourse-cdn.com/v4/letter/t/9e8a1a/32.png) [@tony\_newday](https://community.hubspot.com/u/tony_newday)\
**Post date:** [January 16, 2023, 10:54pm UTC](https://community.hubspot.com/t/hubdb-date-and-time-timezone-issue/72756/4 "2023-01-16T22:54:15Z")

</div>

Thank you, so much!