List:General Discussion« Previous MessageNext Message »
From:James Moe Date:May 26 2003 5:24am
Subject:Re: DEFAULT value for DATETIME field
View as plain text  
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

On Mon, 26 May 2003 12:58:16 +0800, Venkata Srinivasa Rao, Yerra wrote:

>         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 ?);
>
  There is no default for datetime, timestamp, etc.


- --
jimoe at sohnen-moe dot com
pgp/gpg public key: http://www.keyserver.net/en/
-----BEGIN PGP SIGNATURE-----
Version: PGPfreeware 5.0 OS/2 for non-commercial use
Comment: PGP 5.0 for OS/2
Charset: cp850

wj8DBQE+0aUYsxxMki0foKoRAjeFAJ0Q5pRPPI79i4OV8x7ndPmN/wNB7ACgnDCV
AFdSwAttKWlszS5io+2yTW8=
=zRot
-----END PGP SIGNATURE-----


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