title: procedure type date IN param postgresql
body: <p>I want to know how I can enter a parameter within a function type date since at the time of doing so, the following error</p>
  
  <p>report_soat(date, date)</p>
  
  <blockquote>
    <p>Undefined function: 7 ERROR: operator does not exist: date >= character varying LINE 6: BETWEEN fecha_in AND fecha_out ^ HINT: No operator matches the given name and argument type(s). You might need to add explicit type casts. QUERY: SELECT soats.status AS "estado", soats.placa AS "placa" FROM soats where soats.task_id IS NOT NULL and date(soats.created) BETWEEN fecha_in AND fecha_out CONTEXT: PL/pgSQL function report_soat(character varying,character varying) line 2 at RETURN QUERY</p>
  </blockquote>
  
  <pre><code>SELECT 
      soats.status AS "estado",
      soats.placa AS "placa"
  FROM soats 
  where soats.task_id IS NOT NULL and date(soats.created)  
  BETWEEN start_date AND end_date;
  </code></pre>
  
  <blockquote>
    <p>IN start_date date, IN end_date date, OUT status varchar, OUT placa
    varchar</p>
  </blockquote>