title: How to use LIKE with Date columns in Bookshelf?
body: <p>When i try to use <code>LIKE</code> with <code>STRING</code> it will work correctly, but when I try with a <code>DATE</code> type column it will give an Error. This is my controller code:</p>
  
  <pre><code>router.route('/fetchStudentAttendance').post(function(req, res) {
    StudentAttendance
      .query(function(qb) {
        qb.where('date', 'LIKE', '"2018-01%"');
        // qb.where('remarks', 'LIKE', '"A%"'); // this is working
      })
      .where({'class_id': req.body.class_id, 'section_id': req.body.section_id})
      .fetchAll()
      .then(studentAttendance =&gt; {
        let content = {
          data: studentAttendance,
          success: true,
          message: 'Record Not Found',
        };
        return res.send(content);
      })
      .catch(error =&gt; {
        let content = {
          data: error,
          success: false,
          message: 'Error while fetching Student Attendance.',
        };
        return res.send(content);
      });
  });
  </code></pre>
  
  <p>With the Date value it will output the following Error to the console:</p>
  
  <pre><code>code:"42883"
  file:"parse_oper.c"
  hint:"No operator matches the given name and argument type(s). You might need to add explicit type casts."
  length:202
  line:"726"
  name:"error"
  position:"70"
  routine:"op_error"
  severity:"ERROR"
  </code></pre>