Hi there, I’m struggling to understand how to deal with time zones. I have a “Datetime” field in my database, so each time I create a new thing I enter a specific date and time. It seems like I can’t specify a timezone for each entry as well as I can’t select a default timezone for my entire applic…

Hi @leonardodestefanis :wave: I think it was UTC before, But with recent upgrade to bubble version 17 It changes, This post might help you [image] [Breaking Change] Date Parsing on the Server Announcements Hello Everyone, We’re about to introduce a breaking change tha…

Hey @viquarahmed07 thanks for your help! That makes sense. However, if I understand correctly, it refers to the passing dates as text. You have to specify the timezone, otherwise, Bubble will consider the client’s timezone. And that makes sense. However, I would like to pass a date as a date, not a…

@leonardodestefanis sadly :frowning_face: it seems not possible for now (I am not sure Maybe we can wait for other experts opinion too @mikeloc , @adamhholmes ) But definitely you can request bubble for this feature. :slightly_smiling_face: [image] The best way to build web apps without c…

Dates are stored as timestamps…. So time zones don’t come into it… Time zones are only relevant when displaying dates or using them in conditions/workflows etc.

Ok thanks @adamhholmes . So if I have 08/26/2022 10:00 am stored in a date field and considered as a timestamp. I want to display that as UTC, I am going to select a static timezone from the builder. Specifically I am going to pull the timestamp from my date object and will select UTC as static time…

You must be mistaken about the date/time you’ve stored in the DB… the date/time stored is the date/time that will display, regardless of whatever time zone you chose to display it in… How did you store the date/time in the first place?

I stored it manually just for testing purposes. I’ve created a new entry in the Bubble database. Where I can only specify day, month year, hours and minutes.

So you’re setting a date/time in your database, directly in the app datatab (08/26/2022 10:00 am in your own time zone - which is UTC+2), then displaying it in UTC (which is 2 hours behind you), so the time displayed will be 08/26/2022 08:00 am, which is exactly what you’re seeing. So that’s exactl…

I agree. But I am listing a series of virtual events that I want to display in the user’s timezone. I create the events in Airtable and sync with Bubble. In Airtable I can set a default timezone, let’s say that it’s CEST. As soon as I am in CEST, it will work. But let’s say that tomorrow I am in L…

[image] leonardodestefanis: But Bubble will store the date and time in PST No… Bubble stores dates as timestamps… there are no time zones in a Bubble stored date (you can use a time zone to define a timestamp, but a time stamp is absolute… ) If you’re having an issue here, then you must be d…

What is the database's default timezone?

Questions

viquarahmed07 August 26, 2022, 12:54pm 2

Hi @leonardodestefanis
I think it was UTC before,
But with recent upgrade to bubble version 17
It changes, This post might help you

Topic		Replies	Views
Need help understanding how Bubble handles dates/timezones Database	2	666	December 11, 2023
Booking date changing with timezone Need help	9	226	May 17, 2024
Agonizing over inconsistent timezone behaviors Need help	3	432	August 15, 2023
Single timezone for everyone Need help	9	558	July 20, 2021
Upcoming Updates to Timezone Handling in the Backend Announcements	32	6635	December 24, 2022

What is the database's default timezone?

Related topics