Good morning ; How can I make Bubble save only dates in the database… without time ?

In that case you can just ensure you always use the same time zone for the input date and the date used to calculate the difference.

But we can’t use the same time zone because users come from different countries.

This is how dates are recorded on my database (See image below): [image]

Then just use UTC although I can’t understand why you can’t just use the User’s time zone?

If I understood you correctly (see image below)… This user actually entered the date “June 06, 2023 12:00 am”, but Bubble displays the date June 05, 2023 11:00 pm" because of the time zone change? [image]

Oooo this is one of my favorite soapboxes. There’s generally two approaches to this problem: use bubble dates and be careful of time zone usage in the app (this has gotten way easier in recent months). In settings, you can enable the ability to override the timezone of your date pickers, pages, …

Oooo gonna go watch this. The most recent timezone override features add some extra power too.

This is only slightly out of date (as it precedes some Bubble features related to arbitrary date times and timezone overrides), however the core information is still valid as we are just talking about JavaScript date objects and basic concepts like date construction and date formatting, which of sou…

Database / Dates without time

Need help

keith June 14, 2023, 11:47pm 14

But also… Live Bubbling with Keith: Let's Talk About Dates - Explaining the Basics of Dates in Bubble

Topic		Replies	Views
Date only (not time), into the database Need help	18	6581	March 10, 2021
Date fields - What is the formatting used by Bubble? Need help	2	426	November 3, 2022
Date/TimePicker on Bubble Mobile App Builder: Timezone Issue When Saving and Displaying Dates Database	2	128	July 12, 2025
Only store date in data database Database	2	282	January 6, 2023
Need help understanding how Bubble handles dates/timezones Database	2	669	December 11, 2023

Database / Dates without time

Related topics