List:General Discussion« Previous MessageNext Message »
From:Dan Nelson Date:May 26 2003 5:21am
Subject:Re: DEFAULT value for DATETIME field
View as plain text  
In the last episode (May 26), Venkata Srinivasa Rao, Yerra said:
> 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 ?);

Use a TIMESTAMP field type.

-- 
	Dan Nelson
	dnelson@stripped
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