List:General Discussion« Previous MessageNext Message »
From:Martin Ramsch Date:July 26 1999 11:20am
Subject:BENCHMARK() (was: age)
View as plain text  
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.

Regards,
  Martin
-- 
Martin Ramsch <m.ramsch@stripped> <URL: http://home.pages.de/~ramsch/ >
PGP KeyID=0xE8EF4F75 FiPr=52 44 5E F3 B0 B1 38 26  E4 EC 80 58 7B 31 3A D7
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