[thelist] MySQL - column with default of NOW()
Warden, Matt
mwarden at mattwarden.com
Fri Mar 8 18:50:01 CST 2002
On Mar 8, Anthony Baratta had something to say about Re: [thelist] MySQL -...
>Is this what you found?
well, yes. but i didn't read this clearly enough...
<snip>
>TIMESTAMP columns other than the first may also be set to the current date
>and time. Just set the column to NULL or to NOW()."
so, i guess this is implying that the default for the DATETIME datatype
*IS* the current date and time? it seems like that's what it's saying (if
inserting NULL is the same as inserting NOW()).
wow. not sure how i feel about that. i assumed it would have been
'00-00-0000 00:00:00' or the 1970 deal...
anywho, thanks for your help. i think i got it.
--
mattwarden
mattwarden.com
More information about the thelist
mailing list