The current state of the bubble database date format: https://www.facebook.com/share/r/1CcterhJbd/
2 Likes
What’s the bug though?
No doubt date are very hard to deal with , everywhere its not only in bubble.io , because Date is a moment in Time_&_Space, its differemt for everyone.
Like, right now when you are reading this , The Time is same for you and for me
- But i will write/read it differently
- And you will also write/read it differently
- Thats because we both are in different Space in universe.
Sorry for confusing you all 
1 Like
Hope they fix this soon 
1 Like
The database displays date in the legacy am / pm format that a minority of late adopters still use.
It’s kind of a small thing, but also a really really big thing. Consider the confusion and dumb mistakes in data entries in Bubble, fixing the bug, removes form the world 
But hey…
2 Likes
Well written! And a bit of international alignment could make the ancient and modern world move a tad closer, and making it a bit easier for everyone - Unless Josh and Emanuel considers is a quirky “bubble thing” of course
ISO 8601 - yes please
Yeah, it does cause confusion. Not a bug though. Like you said, it’s a Bubble quirk.
1 Like
Actully , bubble store time from user perspective in database, let say i store current date it will store in my Time_&_Space.
and show me my time, but when you are looking it, in database as admin or some one else, bubble Auto convert it to your TIme_&_Space.
this is what confusing
1 Like
Sorry for the bold and nudging post, but it looks like this could turn into a relevant discussion highlighting the confusion you both mention
As a European, I have to decipher the am / pm format almost every time I look at the database, because it’s just not used anywhere close to me. It is “bugging me” to be honest, and anyone I talk about bubble with here in Scandinavia.
I can get use to it yes. When I am in the US, it takes a couple of days to feel natural again, but still… Is the minority of the world using the am / pm format. Many a mix, but the vast majority writing in the 24 hour format, only verbally using the 12 hour format “its 3 in the afternoon”.
It makes me think, is Bubble a US thing, with an international side-thing going on, or is it actually internationally oriented. From users, and the strategic approach. Not to mention all the meet-ups and events around the world. It seems very international.
I am not sure how the 24 hours format it is for north Americans. Its legally adopted in the US, but obliviously not very used, except by the military. Its sound like a bit of an adoption ting, rather than than an active choice.
Is it a “15:00, that’s just 3 pm in the afternoon” or more like a “15:00 o-what?” thing? (asking in blind, in case there are North Americans looking at this).
I would expect that anyone with a degree or just a bit of IT experience is used to the 24hour format.
Also, I haven’t seen the AM / PM format on ANY other platform or builder the last 5-10 years… which its a bit striking to me.
–
@brian.levee (VP of product) You have received your first side-quest - Do you choose to accept?
I’m not sure what’s the issue but i spent the whole week dealing with timezones and the manual has been helpful.
Times and dates – quick facts:
-
Bubble always saves a time and a date (as do most other computer systems).e. You cannot save just one.
-
Time is stored in Unix time, which represents the number of milliseconds since January 1, 1970, 00:00:00 UTC.
-
When displaying time, Bubble automatically converts it to the user’s local time zone unless a timezone override is applied.
-
On the server, Bubble will default to UTC if by the user’s time zone is unavailable and no specific timezone override is provided
1 Like
The issue is that despite in Unix format and auto adjustment to time zones etc.
… time is always displayed on the data tab with am / pm suffix in 12 hour format, catering a minority of bubble users.
Oh, I see. Yeah, I’m an ISO 8601 fanboi myself. I’ve once snorted a line of UNIX epoch but that was too strong for me.
Maybe some enterprising soul can put together a chrome extension that changes it. Not a real solution, but no one’s eyes should bleed daily.
3 Likes
I would say that it caters to a majority of Bubble devs. Code devs are more comfortable with ISO datetimes.
That said I don’t disagree. Before dealing with timezones in Bubble, I meditate for 15 mins to purge my mind of how I work with datetime in code. Light a couple of scented candles, play some environmental sounds, mostly whale sounds.
Then I have to mumble reminders to myself of how Bubble displays date time values whenever I see one. “It’s my timezone… it’s my timezone… it’s my timezone”
I’m from America, but lived in Thailand nearly 14 years. Meters and Kilometers and centimeters are easier than feet and inches.
24 hour time makes more sense than 12 hour AM/PM.
But, with that said, I consider myself a logical thinker, and not an emotional responder to stimuli.
I agree, the date/time display in database should not show AM/PM as only option. Should have simple setting in editor to switch to dev choice since all it is is a formatting display choice and nothing to do with underlying data.
Dates and time are nothing but numbers, either number of milliseconds or seconds, depending on on system, since Epoch time, and time zones are nothing than basic arithmetic from center of earth UTC/GMT.
Thanks for putting this on my radar. I understand the current 12 hour AM/PM format doesn’t work best for many. I’m capturing this opportunity for improvement
2 Likes
Also, some events etc do not need a time but you have to enter one in the DB and it does not seem to allow 00:00:00.
AND WHY are dates SO hard to manipulate of you are not american??? It took me weeks to sort out how to process incoming data that used dd/mm/yy format and needs a plugin to do this, there’s no native way to do this it seems. This adds a LOT of WU etc for something that seems to basic