List:General Discussion« Previous MessageNext Message »
From:Juan Riera Date:September 27 1999 5:37am
Subject:RE: About ISO week # formatting in MySQL
View as plain text  
Hello,
I have been using this option (start week on monday) for weeks, and this is
a very helpful one for all those non-british using MySQL. However, my week
problem is different, as I need to group yearly sales data by week. This
week beggining *today* (monday 27-Sep) is on your week() function week #40,
however on ISO # is week #39 !
As you may suppose, this is not the same for sales team! and I am been
requested to use ISO week # as it is used widely on Spain.
By the moment I am substracting one from week() result, but this will work
only to end december...
Will I see it on next MySQL version?

Regards,
Juan


>
> Note that both the WEEK() function and DATE_FORMAT() can handle weeks
> that starts with Sunday or Monday (another way too look at your week
> problem).
>
> Just take a look in the MySQL manual for the above functions!
>
> Regards,
> Monty
>


Thread
About ISO week # formatting in MySQLJuan Riera26 Sep
  • About ISO week # formatting in MySQLMichael Widenius26 Sep
  • RE: About ISO week # formatting in MySQLJuan Riera27 Sep
    • RE: About ISO week # formatting in MySQLAldrian Gintingsuka27 Sep
    • RE: About ISO week # formatting in MySQLMichael Widenius27 Sep
      • RE: About ISO week # formatting in MySQLbkline28 Sep
        • RE: About ISO week # formatting in MySQLPeter Strömberg28 Sep
      • Re: About ISO week # formatting in MySQLMartin Ramsch28 Sep
        • Re: About ISO week # formatting in MySQLPeter Strömberg28 Sep
          • Re: About ISO week # formatting in MySQLAldrian Gintingsuka28 Sep
            • Re: About ISO week # formatting in MySQLMartin Ramsch28 Sep
            • Re: About ISO week # formatting in MySQLBob Kline28 Sep
          • Re: About ISO week # formatting in MySQLMatthias Urlichs28 Sep
            • Re: About ISO week # formatting in MySQLPeter Strömberg28 Sep
              • Re: About ISO week # formatting in MySQLMichael Widenius29 Sep
            • Re: About ISO week # formatting in MySQLBob Kline28 Sep
              • Re: About ISO week # formatting in MySQLMatthias Urlichs29 Sep
          • RE: About ISO week # formatting in MySQLJuan Riera30 Sep
            • Re: About ISO week # formatting in MySQLMartin Ramsch30 Sep
        • Re: About ISO week # formatting in MySQLMartin Ramsch28 Sep
          • Re: About ISO week # formatting in MySQLBob Kline28 Sep
            • Re: About ISO week # formatting in MySQLMartin Ramsch28 Sep
              • Re: About ISO week # formatting in MySQLBob Kline28 Sep
                • Re: About ISO week # formatting in MySQLMartin Ramsch28 Sep
                  • Re: About ISO week # formatting in MySQLBob Kline29 Sep
                • Re: About ISO week # formatting in MySQLMartin Ramsch29 Sep