Hello there, I have table with a field :dayTime, :utc_datetime and I use Timex to convert the string that I take to a datetime, for example I have a string "29/02/2016 22:55:00" I parse it to ~U[2016-02-29 22:25:00Z] after doing some work then passing it to Timex.parse/2. My problem is when I try to create a new instance and save it to the database I get this error
The migration to create the tables in the database
Also let us know what version of Ecto & related projects (i.e. ecto_sql & postgrex) you are using (maybe just put the contents of mix.exs up).
Also, I note that the date you supply is 29th Feb 2016 which is valid because 2016 was a leap year. Out of interest, have you tried a different date just to help try to isolate the problem. There may be some date validation bug lurking in there, although I followed the code down to the days in month check for 2016 and it seems ok: