Re: Creating Table with a Default Datetime field

[Gerald Clark <gerald_clark@xxxxxxxxxxxxxxxxxxx>]

No. Since the string "now()" is not a valid date it is equivalent to 0, 
so MySQL inserts the current date and time.

Kaneda K wrote:

> At 10:38 27/06/2001 -0700, you wrote:
>
> > Sorry, for quoting the manual but this might be just another example 
> > where
> > it could have the answer right away:
> > Hannes
> >
> > http://www.mysql.com/doc/D/A/DATETIME.html
>
>
> On my own mysql version :
>  Date TIMESTAMP default "now()",
> Works correctly, the date is YYYYMMDDHHmmss format, but the values are 
> set automattically and correctly, so, could it be your mysql version ?
>
>
> ------------------
> System Info :
> Red Hat Linux release 6.2 (Zoot)
>     Kernel 2.2.14-5.0 on an i686
> Mysql Ver 11.12 Distrib 3.23.32
> java version "1.3.0"
>     Java(TM) 2 Runtime Environment, Standard Edition (build 1.3.0)
>     Java HotSpot(TM) Client VM (build 1.3.0, mixed mode)
> JDBC Driver : mm.mysql-2.0.4-bin.jar
> Tomcat 3.2 beta 3
>
>
>
>
> ---------------------------------------------------------------------
> Before posting, please check:
>   http://www.mysql.com/manual.php   (the manual)
>   http://lists.mysql.com/           (the list archive)
>
> To request this thread, e-mail <mysql-thread77902@xxxxxxxxxxxxxxx>
> To unsubscribe, e-mail 
> <mysql-unsubscribe-gerald_clark=suppliersystems.com@xxxxxxxxxxxxxxx>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php


--
Gerald L. Clark
gerald_clark@xxxxxxxxxxxxxxxxxxx


---------------------------------------------------------------------
Before posting, please check:
  http://www.mysql.com/manual.php   (the manual)
  http://lists.mysql.com/           (the list archive)

To request this thread, e-mail <mysql-thread77914@xxxxxxxxxxxxxxx>
To unsubscribe, e-mail <mysql-unsubscribe-treed=ultraviolet.org@xxxxxxxxxxxxxxx>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php