On 28 Sep, 16:04, hygum <thomashy...@gmail.com> wrote:
> this query generates weeknumbers, and shows what the system think is
> the latest week:
> SELECT * , WEEK( datetime )
> FROM tigerens_kodetslyst .kodets_lyst_salg
> WHERE id >0
> ORDER BY `id` DESC
>
> The week column is 38 for posts from today
>
> But my danish mobile phone says its week 39, and thats what this
> authorative webpage also says:http://timeanddate.com/calendar/?year=2007&country=2
>
> the 27th of september 2007 is week 39.
>
> Whats wrong?

Nothing's wrong.

You DID read the section in the manual on this before posting here
didn't you?

http://dev.mysql.com/doc/refman/5.0/...#function_week
http://dev.mysql.com/doc/refman/5.0/...ion_weekofyear