It's a known bug with 3.23.22 - upgrade to the latest version (3.23.30?) and the
problem will go away. Please have a look at the upgrade history in the online manual.
--
Richard Ellerbrock
[EMAIL PROTECTED]
>>> Wolfgang Riedel <[EMAIL PROTECTED]> 2001/01/17 04:39:13 >>>
Hi,
after updating my mysql server to version 3.23.22 on a linux box, I've
found the following problem:
select time_to_sec('03:53:00');
results with the correct value 13980.
But if I use a table of such time dates (in the simplest case: "create
table xy (st time); insert into xy values ('03:53:00'); select
time_to_sec(st) from xy;" I got the wrong result 190800 ...
How can explain this?
With the older version 3.22.23 of mysql it runs correct.
Regards,
Wolfgang
--
[EMAIL PROTECTED]
---------------------------------------------------------------------
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
---------------------------------------------------------------------
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