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?

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

On 28 Sep., 17:16, Captain Paralytic <paul_laut...@yahoo.com> wrote:
> 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/...nctions.html#f...

oops no, thanks