{"action":"created","issue":{"url":"https://api.github.com/repos/orocrm/doctrine-extensions/issues/23","repository_url":"https://api.github.com/repos/orocrm/doctrine-extensions","labels_url":"https://api.github.com/repos/orocrm/doctrine-extensions/issues/23/labels{/name}","comments_url":"https://api.github.com/repos/orocrm/doctrine-extensions/issues/23/comments","events_url":"https://api.github.com/repos/orocrm/doctrine-extensions/issues/23/events","html_url":"https://github.com/orocrm/doctrine-extensions/issues/23","id":156407136,"number":23,"title":"WEEK with mode selector","user":{"login":"lsv","id":20708,"avatar_url":"https://avatars.githubusercontent.com/u/20708?v=3","gravatar_id":"","url":"https://api.github.com/users/lsv","html_url":"https://github.com/lsv","followers_url":"https://api.github.com/users/lsv/followers","following_url":"https://api.github.com/users/lsv/following{/other_user}","gists_url":"https://api.github.com/users/lsv/gists{/gist_id}","starred_url":"https://api.github.com/users/lsv/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/lsv/subscriptions","organizations_url":"https://api.github.com/users/lsv/orgs","repos_url":"https://api.github.com/users/lsv/repos","events_url":"https://api.github.com/users/lsv/events{/privacy}","received_events_url":"https://api.github.com/users/lsv/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":1,"created_at":"2016-05-24T02:29:54Z","updated_at":"2016-05-24T11:15:33Z","closed_at":null,"body":"As week numbers starts different from country to country - mysql have added a \"mode\" selector to week.\r\n\r\nhttps://dev.mysql.com/doc/refman/5.5/en/date-and-time-functions.html#function_week\r\n\r\nYou have hardcoded to 3 in both mysql and postgresql - would it be possible to change this value, so I could write ```WEEK(xxx, 1)``` in my dql - Right now I just get a ```\"[Syntax Error] line 0, col 65: Error: Expected Doctrine\\\\ORM\\\\Query\\\\Lexer::T_CLOSE_PARENTHESIS, got ','\"```\r\n\r\n"},"comment":{"url":"https://api.github.com/repos/orocrm/doctrine-extensions/issues/comments/221238598","html_url":"https://github.com/orocrm/doctrine-extensions/issues/23#issuecomment-221238598","issue_url":"https://api.github.com/repos/orocrm/doctrine-extensions/issues/23","id":221238598,"user":{"login":"x86demon","id":196506,"avatar_url":"https://avatars.githubusercontent.com/u/196506?v=3","gravatar_id":"","url":"https://api.github.com/users/x86demon","html_url":"https://github.com/x86demon","followers_url":"https://api.github.com/users/x86demon/followers","following_url":"https://api.github.com/users/x86demon/following{/other_user}","gists_url":"https://api.github.com/users/x86demon/gists{/gist_id}","starred_url":"https://api.github.com/users/x86demon/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/x86demon/subscriptions","organizations_url":"https://api.github.com/users/x86demon/orgs","repos_url":"https://api.github.com/users/x86demon/repos","events_url":"https://api.github.com/users/x86demon/events{/privacy}","received_events_url":"https://api.github.com/users/x86demon/received_events","type":"User","site_admin":false},"created_at":"2016-05-24T11:15:33Z","updated_at":"2016-05-24T11:15:33Z","body":"Hi, @lsv \r\ndoctrine-extensions provide additional functions and compatibility layer for MySQL and PostgreSQL. Same functions return same results on different platforms.\r\nAccording to ISO\r\n\r\n> The number of the ISO 8601 week-numbering week of the year. By definition, ISO weeks start on Mondays and the first week of a year contains January 4 of that year. In other words, the first Thursday of a year is in week 1 of that year.\r\n\r\nIn the ISO week-numbering system, it is possible for early-January dates to be part of the 52nd or 53rd week of the previous year, and for late-December dates to be part of the first week of the next year. For example, 2005-01-01 is part of the 53rd week of year 2004, and 2006-01-01 is part of the 52nd week of year 2005, while 2012-12-31 is part of the first week of 2013. It's recommended to use the isoyear field together with week to get consistent results.\r\n"}}
{"actor":{"display_login":"x86demon"}}