From: Peter Brawley
Date: January 27 2012 11:00pm
Subject: Re: setting the default of a date field
List-Archive: http://lists.mysql.com/mysql/226694
Message-Id: <4F232CA5.3070803@earthlink.net>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

On 1/27/2012 2:24 PM, william drescher wrote:
> On 1/27/2012 3:21 PM, Peter Brawley wrote:
>> On 1/27/2012 11:18 AM, william drescher wrote:
>>> Is there a way to set the default of a date field to the date
>>> the record is generated ?
>>>
>>> bill
>>>
>>
>> Use a TIMESTAMP. Default DATE(TIME) columns with Triggers.
>>
>> PB
>>
> When I try
> ALTER TABLE `ptInfo` CHANGE `lastQuarterlyReview` 
> `lastQuarterlyReview` DATE NOT NULL DEFAULT CURRENT_TIMESTAMP
> I get:
> #1067 - Invalid default value for 'lastQuarterlyReview'

Yes, if you want a default value use a timestamp column.

PB

-----

>
> bill
>
>