Re: date_format doesn't work correct

2001-07-19 Thread Florian Schmidt
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 > >

RE: date_format doesn't work correct

2001-07-19 Thread Florian Schmidt
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

RE: date_format doesn't work correct

2001-07-19 Thread Florian Schmidt
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' > >

date_format doesn't work correct

2001-07-19 Thread Florian Schmidt
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