Current Server Date/time in UTC instead of users

Questions
33

pepto anyone :slight_smile:?

Here’s my understanding of how bubble handles time:

  1. Say a user does an action on your site, you store the current_date/time field as date, the database will display this value in your timezone.
  2. If instead, you store the current_date/time as a text field, then the database time will be a timestamp of the users time in their timezone.
    In both of the above cases, the current_date/time is taken from the user’s computer which is hopefully right (hence much of the above discussion).

Some other points:
3. In the event you want to store a date and time say from a date picker calendar, the assumed timezone is the user’s timezone.
4. If the assumed timezone isn’t how you want the data stored, then save yourself $40/mo and use the open blockspring timezone converter I created and use to choose a timezone to go with the date picked.

2 Likes