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

Reply via email to