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 <[EMAIL PROTECTED]>
> To unsubscribe, e-mail
> <[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
--
Gerald L. Clark
[EMAIL PROTECTED]
---------------------------------------------------------------------
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 <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php