[Dbix-class] Writing a query with a BETWEEN in the WHERE clause and the to_date(function)

[Joel Bernstein]

2009/9/21 Karen Hoofnagle <karen at hoofnagle.org>:
> I need to create the following query using DBIx:Class (assume I'm using the
> most recent release of DBIx::Class)
> select * from user_read_log where datetime between to_date(20090101,
> 'YYYYMMDD') and to_date(20091001, 'YYYYMMDD')

I think you said you've looked here, but I guess you didn't see this section:

http://search.cpan.org/~ribasushi/SQL-Abstract-1.58/lib/SQL/Abstract.pm#Special_operators_:_IN,_BETWEEN,_etc.

/joel