Not correct. That is internationally different and there should be a
setting for your database whichever you use.
manfred
Joe Conner wrote:
Weeks DO begin on Sunday. Check your calendar.
Dmitri Pissarenko wrote:
Hello!
I have a table with several fields, one of them is a date field.
I want to create a query, which would tell me the week number for
every date. For this purpose I use the following query:
SELECT WEEK(date) AS "Week", date
FROM myTable
This works, however the week number calculation assumes that the week
starts on Sunday and ends on Saturday.
I want the week to start on Monday and end on Sunday.
How should I change the query so that the week number is calculated
for weeks starting on Monday?
TIA
Dmitri Pissarenko
------------------------------------------------------------------------
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
--
Manfred Moser - [EMAIL PROTECTED]
CardioComm Solutions Inc.
201-3060 Cedar Hill Rd.
Victoria BC V8T 3J5 Canada
Phone: (250) 744 1822 Ext. 230
Fax: (250) 744-1866
http://www.cardiocomm.com
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
