Re: Re: Using NOW() with MySQL

[prev] [thread] [next] [Date index for 2004/08/06]

Tony Bowden wrote:

>> On Thu, Aug 05, 2004 at 12:46:17PM +0100, tom@xxxxxxxx.xxx wrote:
>> 
>>>>I have tried all sorts of variations, amazed that I could not just
>>>>add the key-value pair created=>NOW() into the create hash.
>> 
>> Why are you amazed? How would you expect this to work? NOW() is magical
>> in your database, and every database has a large list of similar
>> functions. Class::DBI can't know what to do with these.

I suppose because with other applications/languages I have used/dabbled 
with, there is something similar to the DBI/DBD layers, and those DBIs 
handle magic 'NOW's and 'SYSDATE's. Usually by having a way to let 
through your parameters as they are and trusting the end database to 
know what to do (or error).

>> There's a discussion on the wiki about this:
>> 
>> 	http://www.class-dbi.com/cgi-bin/wiki/index.cgi?SettingDefaultValues

Thank you, a very helpful link.