At 17:51 19.07.2001 +0200, you wrote:
> >>okay, i see this output on my sco-machine:
> >>'2001071614' '2001-07-19 14:00:00'
> >>
> >>if i try the same with mysql-front on my win2k machine:
> >>'2001071914' '2001-07-19 14:00:00'
>
>
>Somehow your sample data doesn't look right: shouldn't it be
>
>
At 09:40 19.07.2001 -0400, you wrote:
>You're correct, likely not a timezone problem.
>
>Have you confirmed that the clocks on these machines are
>synchronized? That they aren't really three days off?
yep, again and agein :)
the clocks are in sync +/- 5 secs
> >okay, i see this output on m
At 09:25 19.07.2001 -0400, you wrote:
>Probably due to timezone setting differences between the two
>client machines.
i also thought about that, but there are 2 DAYs difference... can this be a
timezone issue ?
>okay, i see this output on my sco-machine:
>'2001071614' '2001-07-19 14:00:00'
>
>
Hi!
i've mysql-3.23.39-nt on winnt with a client running under SCO 3.2
i've a simple querry with date_format in it, but date_format isn't doing
what i expect...
sql_string: "select date_format(c.hour, '%Y%m%d%H'), c.hour from count c"
c.hour is DATETIME
okay, i see this output on my sco-ma