Date issue

Hi,
I am running MySQL 4.0.14 with PHP 5.1.4.
I have a table where I'm writing a timestamp field with the now() variable.

When I try to read it (formatted or not), I get a weird date output Year
1933 or 1907.

Any specific setting I'm missing to output my date properly?

Thx in advance.

K.

"Babanou" <mephisto66@yahoo.com> wrote in message
news:h%Fog.112328$8i2.579044@wagner.videotron.net. ..

NOW() returns the current date and time in a specific format. If you are attempting to
modify that format, that may be your problem.

-Lost

So there is absolutely no way to modify the format?

If I want to do so, what should I use?

Thx.



"-Lost" <spam_ninjaREMOVEME@REMOVEMEcomcast.net> wrote in message
news:K4OdnUTBXYf2qz7ZnZ2dnUVZ_vednZ2d@comcast.com. ..
> "Babanou" <mephisto66@yahoo.com> wrote in message
> news:h%Fog.112328$8i2.579044@wagner.videotron.net. ..
>
> NOW() returns the current date and time in a specific format. If you are
> attempting to modify that format, that may be your problem.
>
> -Lost
>

Babanou wrote:
> So there is absolutely no way to modify the format?
>
> If I want to do so, what should I use?

I'd use UNIX_TIMESTAMP() in mysql_database, and take care of the formatting
in PHP using strftime().

Grtz,
--
Rik Wasmus

Great thx.
strtotime works...

..K.


"Rik" <luiheidsgoeroe@hotmail.com> wrote in message
news:25496$44a3c0cb$8259c69c$31314@news2.tudelft.n l...
> Babanou wrote:
>> So there is absolutely no way to modify the format?
>>
>> If I want to do so, what should I use?
>
> I'd use UNIX_TIMESTAMP() in mysql_database, and take care of the
> formatting
> in PHP using strftime().
>
> Grtz,
> --
> Rik Wasmus
>
>