How do you store your user's timezone information?

tz can do it for You…

You provide a naive_datetime (virtual attribute), a timezone, and tz can handle offset and utc itself.

UPDATE: Ouups, I think it’s tzdata that does this

In fact, it’s tz_datetime, sorry

Timezone offsets are not timezones. It tells you almost nothing about the future. Sure the offset might be X today for the user, but how do you know the same still applies tomorrow?

You need the timezone, not just the offset, to do this stuff reliably. I’d also suggest to stick to elixir core APIs nowadays, as besides parsing they can do everything you need. There’s no need to attempt to build your own timezone handling.

tomorrow = "Europe/Berlin" |> DateTime.now!() |> Date.add(1)
DateTime.new(tomorrow, ~T[12:00:00], "Europe/Berlin")
# {:ok, #DateTime<2023-08-25 12:00:00+02:00 CEST Europe/Berlin>}

That’s interesting and makes sense. Are you saying Elixirs core will keep up to date with time zone changes so I should rely on them?

No, you need a library like tz or tzdata to bring in a database of timezones, but elixir itself brings all the necessary APIs to make use of those databases.

To get a little more concrete than my last post:

• Timex.now might already return a different date than the current date of the user (australia is long in the new year before midnight in the usa)
• Shifting a day from an already potentially incorrect base won’t make things more correct.
  • Do you know if this is actually adding a day to the date or plainly adding 24h? That’s quite the difference with timezones in play.
• Shifting the hours expects that the mapping between hours in UTC to the users timezone are fixed. That’s not the case most obviously around DST switches.
• Manually applying any offset should probably be considered a problem on its own. Always let a library do that for you, it probably knows better where to apply which offset.

I store the timezone name (e.g. America/Chicago) in users.time_zone and use that when using Elixir DateTime functions, and they also work with postgres’s AT TIME ZONE in case you want to query users against a given time or datetime.

Ha, didn’t know the part about Postgres, thank you.