eqon133
Ecto, Phoenix and utc datetime
Hello,
I have a Phoenix app using Html.Form datetime_select
I fill user input using Timex zone convert in Europe/Tallinn (UTC+2):
Saved result is same as input
Shouldn’t it be saved as UTC, since all times are UTC in db?
field(:planned_start_at, :utc_datetime)
Q: Where should this convert to UTC? Should i create custom Ecto.Type for this? or in changeset before insert? or can Ecto handle it itself?
inserted_at and updated_at are correctly in UTC
Phoenix 1.4, Ecto 3.0, Postgres
Thanks,
Marked As Solved
eqon133
I will provide my solution here. So i created custom Ecto.Type which will receive local datetime and timezone. And that will convert it to utc.
@behaviour Ecto.Type
def type(), do: :utc_datetime
..
def cast(%{"datetimelocal" => datetimelocal, "tz" => tz}) do
case Timex.parse(datetimelocal, "{ISO:Extended}") do
{:error, _error} ->
Ecto.Type.cast(type(), nil)
{:ok, value} ->
Ecto.Type.cast(type(), Timex.to_datetime(value, tz))
end
end
..
def cast(data), do: Ecto.Type.cast(type(), data)
Also Liked
wojtekmach
When casting a non-UTC %DateTime{} to :utc_datetime it’s gonna be converted to UTC timezone as we can do this safely. After casting it’s all UTC.
As far as storing future date times in UTC that’s indeed dangerous. See @Lau’s excellent blog posts: http://www.creativedeletion.com
OvermindDL1
As I recall :utc_datetime stores timezone information where :naive_datetime does not and stores things as utc always. I think… ^.^;
Regardless, datetimes in the future you want to store with timezone information. Timezones change all the time and if someone plans something on, say, March 18th at 5pm, and daylight savings starts on March 20th but then that gets changed to start on March 12th then if you stored the datetime as utc in the database then you are off by an hour where if you stored it with the proper timezone then it will still be correct. 
Past times are of course fine to store timezoneless.
Popular in Questions
Other popular topics
Latest Phoenix Threads
Latest on Elixir Forum
Sponsor Spotlight
Practical resources that improve the lives of professional developers.
Categories:
Sub Categories:
Forums
Popular Tags
- #ecto
- #liveview
- #troubleshooting
- #learning-elixir
- #deployment
- #library
- #erlang
- #testing
- #genserver
- #mix
- #absinthe
- #remote-other
- #otp
- #plug
- #how-to-question
- #macros
- #postgres
- #channels
- #elixirconf
- #exunit
- #discussion
- #javascript
- #code-sync
- #podcasts
- #onsite
- #dialyzer
- #docker
- #authentication
- #umbrella
- #full-time-contract
- #podcasts-by-brainlid
- #ecto-query
- #elixir-ls
- #phoenix_html
- #iex
- #blog-post
- #graphql
- #genstage
- #ai
- #websockets
- #supervisor
- #advent-of-code
- #elixirconf-us
- #distillery
- #processes
- #forms
- #api
- #metaprogramming
- #security
- #performance
Our Sponsors
Build Elixir applications with speed and confidence.
Supporting innovation across the BEAM ecosystem.
We build reliable cloud platforms for business-critical systems.
Catch errors, track performance, monitor hosts and more.
Real-time error tracking, performance insights, and observability for devs.
Develop your skills with books, videos, and courses.
Producing high quality Elixir screencasts since 2017.
The deployment platform built for Elixir: PaaS ease, VPS control.
Courses that'll move you from confusion to "Aha, now I get it!"