List:General Discussion« Previous MessageNext Message »
From:Michael Widenius Date:September 27 1999 10:10am
Subject:RE: About ISO week # formatting in MySQL
View as plain text  
>>>>> "Juan" == Juan Riera <jriera@stripped> writes:

Juan> Hello,
Juan> I have been using this option (start week on monday) for weeks, and this is
Juan> a very helpful one for all those non-british using MySQL. However, my week
Juan> problem is different, as I need to group yearly sales data by week. This
Juan> week beggining *today* (monday 27-Sep) is on your week() function week #40,
Juan> however on ISO # is week #39 !

Could you please provide an example of your problem:

At least with my MySQL version (should be the same with almost all
MySQL versions):

mysql> select week("1999-09-27");
+--------------------+
| week("1999-09-27") |
+--------------------+
|                 39 |
+--------------------+
1 row in set (0.01 sec)

Juan> As you may suppose, this is not the same for sales team! and I am been
Juan> requested to use ISO week # as it is used widely on Spain.
Juan> By the moment I am substracting one from week() result, but this will work
Juan> only to end december...
Juan> Will I see it on next MySQL version?

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