List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:July 18 1999 10:01pm
Subject:Re: TIMESTAMP values are converted to the "zero"
View as plain text  
At 4:53 PM -0500 7/18/99, E.L. wrote:
>Hi
>
>I am runing MySql 3.22.25 and PHP3
>and when i send  NOW(); as value
>the TIMESTAMP values are converted to the "zero"   00000000000000
>
>and when i send  NOW('1997-10-04 22:23:00'); as value the
>database return correctly 19971004222300
>
>I try to have the current_date and it doesn't seem  to work
>
>same thing for CURTIME();  CURDATE();  UNIX_TIMESTAMP();
>
>
>Am i missing something

Hard to say without seeing the queries.  Since NOW() doesn't
take an argument, what you say above makes me suspect that
there's something odd about the queries themselves.  Let's
see 'em.

--
Paul DuBois, paul@stripped
Thread
TIMESTAMP values are converted to the "zero"E.L.19 Jul
  • Re: TIMESTAMP values are converted to the "zero"Paul DuBois19 Jul