> How about this?
> added datetime default datetime(now()) not null,
Yes, this apparently works by converting from timestamp to datetime.
In general datetime has better dynamic range than does timestamp, but
for calculating 'now' both are equivalent in performance.
- Tom
--
Thomas Lockhart lockhart@alumni.caltech.edu
South Pasadena, California