|
|
| Babanou 2006-06-28, 9:58 pm |
| 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
| |
| Babanou 2006-06-29, 7:58 am |
| 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@co
mcast.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
| |
| Babanou 2006-06-30, 7:58 am |
| Great thx.
strtotime works...
..K.
"Rik" <luiheidsgoeroe@hotmail.com> wrote in message
news:25496$44a3c0cb$8259c69c$31314@news2
.tudelft.nl...
> Babanou wrote:
>
> I'd use UNIX_TIMESTAMP() in mysql_database, and take care of the
> formatting
> in PHP using strftime().
>
> Grtz,
> --
> Rik Wasmus
>
>
|
|
|
|