7 messages in com.mysql.lists.perlRe: defaulting dates to now() ??
FromSent OnAttachments
Sean Cannon15 Jun 2001 07:33 
Mike<mickalo>Blezien15 Jun 2001 09:12 
Pete Harlan15 Jun 2001 13:04 
Mike<mickalo>Blezien15 Jun 2001 14:24 
Keith Schincke15 Jun 2001 14:31 
Todd Finney15 Jun 2001 15:12 
Brian Collins15 Jun 2001 15:58 
Subject:Re: defaulting dates to now() ??
From:Mike<mickalo>Blezien (mick@bellsouth.net)
Date:06/15/2001 02:24:05 PM
List:com.mysql.lists.perl

On Fri, 15 Jun 2001 15:04:33 -0500 (CDT), Pete Harlan <har@artselect.com> wrote:

Right you are! I mis-read the message. Sorry about that.

On Fri, 15 Jun 2001 10:33:56 -0400, "Sean Cannon" <scan@ccgroupnet.com> wrote:

use TIMESTAMP

this is the same as NOW();

No it isn't. (Because it changes when the record is updated.)

How do I go about making a date, datetime, or whatever default to now()? Specifying now() in the column create clause doesn't work...

You can't, unfortunately.

Mike(mickalo)Blezien ======================================== Thunder Rain Internet Publishing Providing Internet Solutions that work! http://www.thunder-rain.com Tel: 1(225) 686-2002 =========================================