Simple question, how to add a default Ecto.Date value to a field without using timestamp? alter table(:registro) do modify :data, :date, [null: false, default: Ecto.Date.utc()] end I know that this isnt the right way to do, but the exception still bugs me (ArgumentError) unknown default…

I believe a fragment is best described as ‘custom sql’ the now() function is a function in postgres PostgreSQL: Documentation: 9.6: Date/Time Functions and Operators modify :data, :date, [null: false, default: fragment("now()")] should work, although you are using a date field, so I’m not 100…

the exception message is actually pretty good.. you need to use a fragment - see docs for solution :slight_smile: https://hexdocs.pm/ecto/Ecto.Migration.html#fragment/1

Ok, can you explain whats a fragment and how to use it? create table(:posts) do add :inserted_at, :naive_datetime, default: fragment("now()") end the fragment() function is calling a now() function?

Elixir Programming Language Forum

Default :date in Migration

Questions & Help Questions

umbra March 21, 2017, 5:41pm 5

Thank you very much! =)