Hi everybody !
Does anybody has to do it ?
I had to know the first of a week number nweek ?
What is the best solution, because it is in a loop (scan for ...) of a
big DBF.
Fred.
by Frédéric Steczyck » Fri, 09 Jul 1999 04:00:00
Does anybody has to do it ?
I had to know the first of a week number nweek ?
What is the best solution, because it is in a loop (scan for ...) of a
big DBF.
Fred.
by Mike Welbor » Sat, 10 Jul 1999 04:00:00
It returns 1-7, the default setting has 1 = Sunday, but than can be changed.
Mike
Quote:> Hi everybody !
> Does anybody has to do it ?
> I had to know the first of a week number nweek ?
> What is the best solution, because it is in a loop (scan for ...) of a
> big DBF.
> Fred.
by Anders Altber » Sat, 10 Jul 1999 04:00:00
theyear= 1999
theweek= 27
thedate1 = DATE(theyear,1,1)+7* theweek
thedate2 = thedate1 - DOW(thedate1,2)+1
? CDOW(thedate2), thedate2
Monday 1999-07-05
Day 1 of week 1 1999 was Monday Jan 4. Day 1 of week 1 year 2000 will be
Monday, Jan 3.
-Anders
Quote:> Hi everybody !
> Does anybody has to do it ?
> I had to know the first of a week number nweek ?
> What is the best solution, because it is in a loop (scan for ...) of a
> big DBF.
> Fred.
by Frédéric Steczyck » Tue, 13 Jul 1999 04:00:00
Thank you !
Fred
1. HELP: First Day in Week Setting and First Week in Year Help
1.
I would like to change the SQL-Server 7 configuration for
- the first day of week to Monday and NOT Sunday AND
- that the first week in a year is the first full week
I know the configuration option "SET DATEFIRST", but this is only for a
session.
I would like to change these settings ONCE for the whole SQL Server.
2.
Found something interesting:
If I want to fill a table with all weeks from 1997 to 2005 and a unique ID,
sometimes,
weeks are missing (2000-01) for example... This problem starts with 2000...
Y2K Problem?
But this problem only happens, if I set the first day of week to Sunday, if
it is set to Monday, it works!
I am confused... PLEASE HELP!
Here is the code for it:
CREATE TABLE [dbo].[DBL_Dates] (
[Number] [T_PCID] NOT NULL,
[Week] VARCHAR(6) NOT NULL
CONSTRAINT [PK_DBL_Dates] PRIMARY KEY ( [Number] )
) ON [PRIMARY]
SET DATEFIRST 7 -- 7 does NOT work, 1 works
BEGIN
BEGIN
END
also... thats why I tried with DAY
END
2. Indexing Service + ASP work fine Locally but not on Separate Servers
3. Date of the first day of the week
4. Reinstalling SQL Server 6.5 failing
5. Getting the first day of a calendar week (Date Format)
6. What's up on DataB's Standards
7. Finding the day date from week number
8. Visual FoxPro compared to Visual Basic
10. set the first day of the week
11. How to set up the first week day for the DateDiff