Beefy Boxes and Bandwidth Generously Provided by pair Networks
Come for the quick hacks, stay for the epiphanies.
 
PerlMonks  

Re^2: Date subtraction (intervals) w/Class::DBI

by waswas-fng (Curate)
on Oct 15, 2004 at 18:02 UTC ( [id://399594]=note: print w/replies, xml ) Need Help??


in reply to Re: Date subtraction (intervals) w/Class::DBI
in thread Date subtraction (intervals) w/Class::DBI

Not so true anymore depending on the version you are running:

Beginning with MySQL 4.1.2, you have more flexible control over when a +utomatic TIMESTAMP initialization and updating occur and which column + should have those behaviors: You can assign the current timestamp as the default value and the auto +-update value, as before. But now it is possible to have just one aut +omatic behavior or the other, or neither of them. You can specify which TIMESTAMP column to automatically initialize or +update to the current date and time. This no longer need be the first + TIMESTAMP column. The following discussion describes the revised syntax and behavior. No +te that this information applies only to TIMESTAMP columns for tables + not created with MAXDB mode enabled. As noted earlier in this sectio +n, MAXDB mode causes columns to be created as DATETIME columns. </i>
... more info at: MySQL doc page.


-Waswas

Log In?
Username:
Password:

What's my password?
Create A New User
Domain Nodelet?
Node Status?
node history
Node Type: note [id://399594]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this?Last hourOther CB clients
Other Users?
Others surveying the Monastery: (4)
As of 2024-04-24 12:12 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found