List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:July 26 1999 4:46pm
Subject:Re: BENCHMARK() (was: age)
View as plain text  
At 1:20 PM +0200 7/26/99, Martin Ramsch wrote:
>On Sa, 1999-07-24 10:18:21 -0500, Paul DuBois wrote:
>> SELECT
>> BENCHMARK(1000000,
>>           year(FROM_DAYS(TO_DAYS("1999-7-24")-TO_DAYS("1972-1-1"))));
>> SELECT
>> BENCHMARK(1000000,
>>           FLOOR((TO_DAYS("1999-7-24")-TO_DAYS("1972-1-1"))/365.25));
>
>Am I right and this funtion is missing in the manual?
>
>I just found a small note in chapter "19.3.5 Changes in release
>3.22.15" reading:
>| * Added BENCHMARK(loop-count,expression) function to time expressions.


It's in chapter 7 under miscellaneous functions.

-- 
Paul DuBois, paul@stripped
Thread
ageMichael Farr24 Jul
  • Re: agetonu24 Jul
    • Re: ageMichael Farr24 Jul
    • Re: agePaul DuBois24 Jul
      • Re: agetonu-mysql25 Jul
  • Re: agePaul DuBois24 Jul
    • BENCHMARK() (was: age)Martin Ramsch26 Jul
      • Re: BENCHMARK() (was: age)Paul DuBois26 Jul
        • Re: BENCHMARK() (was: age)Martin Ramsch26 Jul
Re: age(Timo Maier)26 Jul
  • Re: ageLindsay Davies27 Jul
Re: ageFulko Hew26 Jul