TIMESTAMP is not the solution to his problem; he wants the date to
default to now() when the record is created, not updated.
There's currently no way to do this in MySQL; default values must be
constants.
--Pete
> hi.
>
> check out the TIMESTAMP column type...maybe TIMESTAMP(14) as the column
> type?
> you can then format the date accordingly with...uh...DATE_FORMAT() in your
> select statements...
>
> hth.
> -ravi
>
>
> -----Original Message-----
> From: Richard Bates [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, June 26, 2001 3:00 PM
> To: [EMAIL PROTECTED]
> Subject: Creating Table with a Default Datetime field
>
>
> How do I get a default date time in the create table clause...
>
> I have tried
>
> Create table(
> CreationDate DATETIME DEFAULT NOW(),
> Info varchar(100)
> );
> Create table(
> CreationDate DATETIME DEFAULT "NOW()",
> Info varchar(100)
> );
>
> Create table(
> CreationDate DATETIME DEFAULT SYSDATE(),
> Info varchar(100)
> );
> Create table(
> CreationDate DATETIME DEFAULT "SYSDATE()",
> Info varchar(100)
> );
>
> Create table(
> CreationDate DATETIME DEFAULT CURRENT_DATE(),
> Info varchar(100)
> );
> Create table(
> CreationDate DATETIME DEFAULT "CURRENT_DATE()",
> Info varchar(100)
> );
>
> All without the quote return with invalid syntax.
> With the quote inserts "000-00-00 00:00:00" meaining invalid date.
> ==================================
> === Richard Bates
> === TELEHOUSE America
> ==================================
>
>
>
> ---------------------------------------------------------------------
> Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail <[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
>
>
> ---------------------------------------------------------------------
> Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail <[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
