Re: Re: Using NOW() with MySQL

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

On Fri, Aug 06, 2004 at 05:04:02PM +0100, tom@xxxxxxxx.xxx wrote:
> 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).

Can you give any specific examples of what you mean?

Tim.