List:General Discussion« Previous MessageNext Message »
From:Yerra Venkata Srinivasa Rao Date:May 26 2003 4:58am
Subject:DEFAULT value for DATETIME field
View as plain text  
Hi All,

         Any body knows how to set system date & time as a default value to 
a field of type DATETIME while creating the table.

CREATE TABLE test(id INT(10), createdate DATETIME DEFAULT ?);

Thanks in advance.

Best Regards,
Yerra
Thread
• sql error help?trogers25 May
  • Re: sql error help?Joseph Bueno25 May
  • SQL and WAP? (newbie)2Hosts.com25 May
    • RE: SQL and WAP? (newbie)Michael S. Fischer25 May
      • Re: SQL and WAP? (newbie)2Hosts.com26 May
        • DEFAULT value for DATETIME fieldYerra Venkata Srinivasa Rao26 May
          • Re: DEFAULT value for DATETIME fieldDan Nelson26 May
            • Re: DEFAULT value for DATETIME fieldYerra Venkata Srinivasa Rao26 May
              • Re: DEFAULT value for DATETIME fieldDan Nelson26 May
          • Re: DEFAULT value for DATETIME fieldJames Moe26 May
    • need favour ;)n0n4m326 May