title: migrate postgre function to mysql: retrieve date range
body: <p>I would like to migrate this postgre function to mysql. The function receives two dates as a parameter and returns an array with the intermediate dates received.</p>
  
  <p>example: </p>
  
  <p>send two dates '2019-01-01' &amp; '2019-05-31'.</p>
  
  <p>i get: {'2019-01-01','2019-02-01','2019-03-01','2019-04-01','2019-05-01'}</p>
  
  <p>The function postgre:</p>
  
  <pre><code>    CREATE OR REPLACE FUNCTION schema.date_range(
      start_date date,
      end_date date)
  RETURNS date[]
      LANGUAGE 'plpgsql'
      COST 100
      VOLATILE 
  --    ROWS 0
  AS $BODY$
  
  DECLARE
  date_exe date := start_date;
  array_date date[];
  BEGIN
  
  WHILE date_exe &lt;= end_date
  LOOP
      -- MAKE YOUR STUFF
      RAISE NOTICE '%', date_exe;
      array_date := array_append(array_date,date_exe);
      date_exe := date_exe + interval '1 month';
  END LOOP;
  
  RETURN array_date;
  
  END;
  
  $BODY$;
  </code></pre>
  
  <p>The idea is to insert in a table the periods per month between two dates, with the range returned (from the postgre function)
  performed a for loop to insert these values:</p>
  
  <pre><code>SET array_date_range = schema.date_range( '2019-01-01', '2019-05-31'); -- function I want to migrate
  
  for i in  coalesce(array_lower(array_date_range, 1),1)..coalesce(array_upper((array_date_range, , 1),1) loop
  
  
   SELECT LAST_DAY((array_date_range[i]) INTO v_date_end;
  
  
   INSERT INTO schama.table (date_ini, date_end)
  
   VALUES (array_date_range[i] ,v_date_end);
  
  end loop;
  </code></pre>
  
  <p>thanks in advance</p>