[wp-trac] [WordPress Trac] #10397: Start of week and WEEK mysql date function

WordPress Trac wp-trac at lists.automattic.com
Wed Jan 27 17:13:44 UTC 2010


#10397: Start of week and WEEK mysql date function
-------------------------------------+--------------------------------------
 Reporter:  arena                    |        Type:  defect (bug)
   Status:  new                      |    Priority:  normal      
Milestone:  3.0                      |   Component:  Date/Time   
  Version:  2.9                      |    Severity:  major       
 Keywords:  needs-patch dev-feedack  |  
-------------------------------------+--------------------------------------

Comment(by arena):

 if WordPress wants to support iso 8601 as the default

 When using "WEEK" MySql function, second argument should have the value :
 3

 (there are no 0 (zero) week in iso 8601).


 "WEEK" MySql function is used in two wp files :

 wp-includes/general-template.php

 wp-includes/query.php

 More info :

 http://en.wikipedia.org/wiki/ISO_8601

 http://dev.mysql.com/doc/refman/5.1/en/date-and-time-
 functions.html#function_week

-- 
Ticket URL: <http://core.trac.wordpress.org/ticket/10397#comment:17>
WordPress Trac <http://core.trac.wordpress.org/>
WordPress blogging software


More information about the wp-trac mailing list