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
>
> >>'2001071614' '2001-07-16 14:00:00'
> ^
exactly this is the bug!
the date at this time was: '2001-07-19 14:00:00' and now() correctly
reports this, but a date_format(now(), '%Y%m%d%H') says '2001071614' with
16 as the month-day instead of 19 which would be right !?
--
Florian Schmidt
mailto:[EMAIL PROTECTED]
http://www.f-24.com
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php