* [Dbix-class] Re: how to specify current timestamps in a ->search operation in DBIx::Class?

[kakimoto at tpg.com.au]

hello, Tom!
 found the syntax!

Something like this, " ->search({'created_time' => { '>=', '2006-06-01
00:00:00' } })" has worked well for me!

by the way, there is something wrong with the mailing list because I
can;t get any replies. I had to manually check the searchable archive .


Can some admins please help?

thanks 

k. akimoto




[Dbix-class] Re: how to specify current timestamps in a ->search
operation in DBIx::Class?

Tom Hukins
Thu, 25 Jun 2009 01:32:51 -0700

On Thu, Jun 25, 2009 at 02:04:24PM +1000, kakim... at tpg.com.au wrote:
> I have looked through SQL::Abstract and well, got stuck as I don't know
> how to specify "NOW()".
> 
> My question is, how do we do current time comparisons in DBIx::Class'
> where clause filter for a DBIx::Class->search call please? :)

The examples in the FAQ should help:
http://search.cpan.org/~ribasushi/DBIx-Class-0.08107/lib/DBIx/Class/Manual/FAQ.pod#Searching

If they don't, let us know how to improve them to make this easier to
understand.

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/dbix-class@lists.scsys.co.uk