On Thu, Jun 25, 2009 at 08:13:07PM +1000, [email protected] wrote: > Something like this, " ->search({'created_time' => { '>=', '2006-06-01 > 00:00:00' } })" has worked well for me!
But in your original question you asked: > > I have looked through SQL::Abstract and well, got stuck as I don't know > > how to specify "NOW()". If you trace the search() query with 'created_time' you wrote above, you'll see it includes "2006-06-01 00:00:00" in the SQL, not "NOW()": http://search.cpan.org/~ribasushi/DBIx-Class-0.08107/lib/DBIx/Class/Manual/Troubleshooting.pod#Tracing_SQL You want to pass search() a scalar reference to the string 'NOW()' as described in the first link I sent. Tom _______________________________________________ List: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/dbix-class IRC: irc.perl.org#dbix-class SVN: http://dev.catalyst.perl.org/repos/bast/DBIx-Class/ Searchable Archive: http://www.grokbase.com/group/[email protected]
