DATEFIRST Independent ISO Monday Function Required

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Development (2000)

DATEFIRST Independent ISO Monday Function Required

Author

Topic

TerryBurns
Starting Member

1 Post

Posted - 2006-11-15 : 05:13:18

Hi,

I was wondering if anyone has a NON DATEFIRST dependent function which can return the Monday of any given year,ISO week where the first day of the week is Monday.

Thanks in advance

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2006-11-15 : 05:21:40

Search for a function made by Michael Valentine Jones here at SQLTeam.
The function is called F_TABLE_DATE.

Peter Larsson
Helsingborg, Sweden

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2006-11-15 : 07:41:40

or http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=61519

Madhivanan

Failing to plan is Planning to fail

Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)

7020 Posts

Posted - 2006-11-15 : 07:55:55

The following functions can be used to return ISO weeks. The date table function, F_TABLE_DATE, mentioned in the other posts also has columns for ISO weeks. All are independant of DATEFIRST.

ISO Year Week Day of Week Function:
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=60515

ISO Week of Year Function:
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=60510

Other Date/Time Info and Script Links here:
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=64762

CODO ERGO SUM

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources