How do I filter on mysql date?

From: Frank (farocc..otmail.com)
Date: Fri Mar 16 2007 - 09:45:31 EDT

  • Next message: Peter Schr�der: "AW: How do I filter on mysql date?"

    Hello,

    I need to show the last 60 days of records from my MySQL database.
    This is not working.

        private List filter() {
         Calendar c = new GregorianCalendar();
         c.set(c.get(Calendar.YEAR),(c.get(Calendar.MONTH)-60), 1, 0, 0, 0);
         DataContext context = DataContext.getThreadDataContext();
         Expression qualifier3 = Expression.fromString("appDate > $date");
         qualifier3 = qualifier3.expWithParameters(Collections.singletonMap("date", c.getTime()));
         SelectQuery select3 = new SelectQuery(HRApplications.class, qualifier3);
         List records = context.performQuery(select3);
         return records;
        }

    What am I doing wrong?

    Thanks
    Frank

    This archive was generated by hypermail 2.0.0 : Fri Mar 16 2007 - 09:46:19 EDT