Users are inputting the time zone as say 7:00 PM local time, but when Bubble stores it or something and API calls are made out of the app using the date, the date is 11:00PM. Why is this? Is everything in UTC? How do I get the dates to be correct and correlate to the dates inside of the Bubble ap…

Bubble automatically collects and outputs times in user’s time-zone. This works amazingly well most of the time. However, when you do more advanced things with it, then it can get quite complicated. For example, if you want to, say, send that time to a third party you also need to have collected …

I looked through the forum. Can anyone confirm that any time collected without designating or setting a timezone on collection is in UTC and this is why 7:00 PM becomes 11:00 PM when sent via the API connector? And is the work around to this to ensure that the information in the bubble DB is accur…

I believe Bubble stores it in UTC, but I’m not 100% sure anymore. That said, you can easily format the time to display in a different timezone when sending to an API, displaying in bubble, etc. Just select “format as” right after referencing the time. Hope this helps.

Yes but how do you collect the time zone based on a departure city which could be elsewhere, and then pass that timezone along with the API call? Think about booking a trip from one city that departs from another city destined for a third city. Three different time zones are in effect.

The way we’ve done it is translate the input time to UTC (which means we translate it dynamically based on the user’s current time zone). We set-up an algorithm for this on blockspring and just call it. So, it’s simple for us now that we have the blockspring code. Took a bit of work to get it the…

Whitney set-up the blockspring we use for public use actually, so you’re more than welcome to use it. It makes all of this quite easy. Here’s a link to her post in the forum.

When I save the inputted information to the DB it is already in UTC time. How do I save the time based on another field (the departure location/city) within the same input form? For example a flight departure at 3:00 PM Rome time traveling to London U.K.?

Oh, fun with timezones… First, I always structure my times in yyyy-mm-dd"T"HH:MM:ss"Z" format when I send them through an API [image] Custom Format = yyyy-mm-dd"T"HH:MM:ss"Z" An easy way to convert 3pm Rome Time → 2pm London Time would be to use this custom block The timezone inputs to the bloc…

Doesn’t look like the custom block works anymore with Bubble for this unfortunately.

Are you seeing an error? I just re-tested it and it worked for me.

Time Zone Issue

Need help

grace.hong July 11, 2022, 8:20pm 16

Hi there, we just released two features giving you more control over handling timezones. Learn more here: New features to override timezones

Topic		Replies	Views
Time Zone Related Question & Bubble Questions	13	5362	July 9, 2020
3 Timezones Effecting A Date / Time Need help	0	308	July 5, 2019
Steps To Store All Dates In UTC In Bubble? Need help	5	3042	August 15, 2019
Date Issue in Bubble APIs	5	612	September 16, 2021
What is the database's default timezone? Questions	12	7095	August 27, 2022

Time Zone Issue

Related topics