I strongly suggest to declare your datetime columns as such and use DateTime->now() to get the actual datetime and use that object for your dbic calls! This way you are dbms independent.
-Alex -----Original Message----- From: Charles Alderman [mailto:[EMAIL PROTECTED] Sent: Friday, May 02, 2008 8:13 PM To: [email protected] Subject: Re: [Dbix-class] oracle sysdate? Jennifer, I have not ever used oracle sysdate with DBIx::Class, but I just figured out how to use mysql's now(), which was not immediately obvious to me. I don't know if you're having the same issue, but I'll describe what happened to me. I have a timestamp column called 'last_updated', and I want to update it to the current time. <code> $row = $schema->resultset(...)->find(...); # This doesn't work because it treats the 'NOW()' string as a binded variable. # it crashes because its pushing the literal 'NOW()' into the timestamp column $row->last_updated('NOW()'); $row->update; # This does work because when passing in a ref to the scalar, # bind vars aren't used. $row->update( { last_updated => \'NOW()' } ); </code> Maybe the same thing applies to what you're doing with SYSDATE? Thanks, Charles Alderman ----- Original Message ----- From: Jennifer Ahn <[EMAIL PROTECTED]> Sent: Wed, 30 Apr 2008 09:42:25 -0700 Re: [Dbix-class] oracle sysdate? > hello! > > has anybody successfully used the oracle sysdate using dbix:class? > > thanks! > > jennifer > > _______________________________________________ > 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] _______________________________________________ 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] *"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"* T-Systems Austria GesmbH Rennweg 97-99, 1030 Wien Handelsgericht Wien, FN 79340b *"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"* Notice: This e-mail contains information that is confidential and may be privileged. If you are not the intended recipient, please notify the sender and then delete this e-mail immediately. *"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*
_______________________________________________ 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]
