At 5:22 PM +0200 10/2/01, Malko Malko wrote:
>>Description:
>When multiplying a date field with a number( any type ) field
>for some values in any of these 2 fields mysql did nt answer to
>queries.
>>How-To-Repeat:
>#
># Table structure for table 'testdate'
>#
>
>CREATE TABLE testdate (
Malko Malko writes:
> mysql> select date,coef,sec_to_time(time_to_sec(date*coef)) from testdate;
Why do you multiply the date with a number and then convert
it to a number? Shouldn't it be the other way around? :-O
//C
--
Carl Troein - Círdan / Istari-PixelMagic - UIN 16353280
[EMAIL PROTE
>Description:
When multiplying a date field with a number( any type ) field for
some values in any of these 2 fields mysql did nt answer to queries.
>How-To-Repeat:
#
# Table structure for table 'testdate'
#
CREATE TABLE testdate (
ID int(11) NOT NULL auto_increment,
DATE time DEFA
