How do I set MySQL column to current date on insert only?
Posted: Wed Feb 05, 2003 3:36 pm
Where do I apply this:
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().
If I set the column to NULL or put NOW() in the default value then date comes up 0000-00-00 upon record insert.
If I put a hidden field and submit 0000-00-00 I get same result.
So how do I just get date once upon record creation?
Thanks
RR
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().
If I set the column to NULL or put NOW() in the default value then date comes up 0000-00-00 upon record insert.
If I put a hidden field and submit 0000-00-00 I get same result.
So how do I just get date once upon record creation?
Thanks
RR