List:General Discussion« Previous MessageNext Message »
From:Yerra Venkata Srinivasa Rao Date:May 26 2003 5:29am
Subject:Re: DEFAULT value for DATETIME field
View as plain text  
Dear Nelson,

         TIMESTAMP type field data will be modified whenever the record get 
updates.
         I don't want lose the original date & time because I want to keep 
record create date & time.

Best Regards,
Srinivas.
At 12:21 AM 5/26/2003 -0500, Dan Nelson wrote:
>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
>
>--
>MySQL General Mailing List
>For list archives: http://lists.mysql.com/mysql
>To unsubscribe:    http://lists.mysql.com/mysql?unsub=1

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