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 [at] yahoo.com> wrote in message
news:h%Fog.112328$8i2.579044 [at] 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 [at] REMOVEMEcomcast.net> wrote in message
news:K4OdnUTBXYf2qz7ZnZ2dnUVZ_vednZ2d [at] comcast.com...
> "Babanou" <mephisto66 [at] yahoo.com> wrote in message
> news:h%Fog.112328$8i2.579044 [at] 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 [at] hotmail.com> wrote in message
news:25496$44a3c0cb$8259c69c$31314 [at] news2.tudelft.nl...
> 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
>
>