# Issue with dates and timezones with PostgreSQL

**URL:** <https://community.glideapps.com/t/issue-with-dates-and-timezones-with-postgresql/72326>\
**Category:** Report a Bug\
**Created:** [April 4, 2024, 9:42pm UTC](https://community.glideapps.com/t/issue-with-dates-and-timezones-with-postgresql/72326 "2024-04-04T21:42:38Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Nate\_H](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/nate_h/32/44900_2.png) [@Nate\_H](https://community.glideapps.com/u/Nate_H)\
**Post date:** [April 4, 2024, 9:42pm UTC](https://community.glideapps.com/t/issue-with-dates-and-timezones-with-postgresql/72326/1 "2024-04-04T21:42:38Z")

</div>

**Team ID: dzOTuFSjeNjyZuZBUiEs**  
**App ID: asDyVJMVFdcQYTer7Hnf**

I’m in the process of migrating our timekeeping / invoicing app to a PostgreSQL backend. I’m having an issue storing and retrieving dates.

I have a user use a date picker (date only - no time) to enter date into a helper table as part of a time entry input. The date gets stored in the helper table as, i.e., **4/4/2024, 12:00:00 AM**

This later gets written to my PostgreSQL table (the column is type date - but it doesn’t really matter if it’s timestamp or timestamptz, the result is the same) as **2024-04-04** but Glide reads **2024-04-04T00:00:00Z**

Then, when Glide parses the date, it’s converted to local time, so I get **4/3/2024 at 8:00pm** I only really care about the date, so for my purposes the date is wrong. It shows 4/3/2024 as the date in my app, even though the user entered 4/4/2024.

I’ve referred to this thread: [Date filled does not match the date showing up in data](https://community.glideapps.com/t/date-filled-does-not-match-the-date-showing-up-in-data/55166). The issue I’m having seems to be caused by the same thing but I wasn’t able to find a fix there.

---

<div class="post-metadata">

**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\
**Post date:** [April 4, 2024, 10:50pm UTC](https://community.glideapps.com/t/issue-with-dates-and-timezones-with-postgresql/72326/2 "2024-04-04T22:50:01Z")

</div>

Hi Nate,

Please open a support ticket for this. Thank you!

> [@How to open a support ticket?](https://community.glideapps.com/t/how-to-open-a-support-ticket/59883/2):
>
> Please note: the option to create a support ticket is only available if your App is in a Pro, Business or Enterprise Team. If you need help with a Billing Issue (on any plan), you should open a Billing Enquiry via the [Glide Support Page](https://www.glideapps.com/support). To create a Support Ticket: Open the App that is giving you problems, and go to Settings → Contact Support: Glide will prompt you to create a support link for your App. Click on Create Link:

---

<div class="post-metadata">

**Author:** ![system](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/system/32/53398_2.png) [@system](https://community.glideapps.com/u/system)\
**Post date:** [October 1, 2024, 10:50pm UTC](https://community.glideapps.com/t/issue-with-dates-and-timezones-with-postgresql/72326/3 "2024-10-01T22:50:20Z")

</div>

This topic was automatically closed 180 days after the last reply. New replies are no longer allowed.