List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:June 26 2001 8:21pm
Subject:Re: Default Datetime?
View as plain text  
At 2:43 PM -0400 6/26/01, Richard Bates wrote:
>How do I get a default date time in the create table clause...

The MySQL Reference Manual states that DEFAULT values must be constants.

Insert NOW() into the field when you create new records.

>
>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
>==================================


-- 
Paul DuBois, paul@stripped
Thread
Default Datetime?Richard Bates26 Jun
  • Re: Default Datetime?Paul DuBois26 Jun
    • Re: Default Datetime?Sherzod Ruzmetov26 Jun
      • Re: Default Datetime?Harald Fuchs27 Jun