January 1 showing as week 52 of the next year, not 53 of previous year.
BlakeLucchesi - October 6, 2009 - 20:15
| Project: | Weekly Archive by Node Type |
| Version: | 6.x-2.4 |
| Component: | Code |
| Category: | bug report |
| Priority: | normal |
| Assigned: | Prometheus6 |
| Status: | closed |
Jump to:
Description
This patch adjusts the sql query so that we get the proper year and week number for nodes posted on the first few days of january.
For reference: http://dev.mysql.com/doc/refman/5.1/en/date-and-time-functions.html#func...
Not sure if this works for postgres, I can't test that.
| Attachment | Size |
|---|---|
| yeardate.patch | 1.51 KB |
#1
Thanks, I guess I still need to review this some more. The issue is getting PHP and MySQL to play nice together...they don't parse out the weeks the same way. If everyone in the world started their week on Monday, it would be easy.
#2
Patch applied, thanks.
#3
Automatically closed -- issue fixed for 2 weeks with no activity.