Migrating a date field from a legacy mysql database that only contains the year portion (1950-0-0) works both with date and an iso-date field, except.... the year decrements by -1. The node created therefore has the year 1949.

I read through the "Fuzzy granularity" thread but I feel the year field should not be categorized as a fuzzy granularity since it´s the most parent value in the hierarchy.

Is this a known issue?

Comments

busla’s picture

busla commented

quick solution to this was to add a month and day value to the field in every row. Since I will never query the month or day in these date fields I´m using the inserted values don´t really matter. I´m still curious why this happened.

Also... I had to add $year-01-31 to the field. $year-01-01 didn´t work or any values up to the 12th of january but 13th and up did work.

From 1st-12th I also got a default year value of '2001'.

Weird.