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.
| Author |
Topic |
|
sreenu9f
Yak Posting Veteran
73 Posts |
 Posted - 2010-04-22 : 11:47:31
|
| I would like to get week extracted from the datetime column but the problem with datepart function is it calculates the week from sunday. i would like to start a week from a specific day of week. for example Apr 1 (Thursday) as the start of the week and ends at wednesday 7th of april.can some one suggest if it is possible to do that way.Thanks |
|
|
pk_bohra
Master Smack Fu Yak Hacker
1182 Posts |
Posted - 2010-04-22 : 11:56:17
|
| Check the below link. It may of some help to youhttp://www.sqlteam.com/forums/topic.asp?TOPIC_ID=47307 |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
|
|
deepakugale
Starting Member
33 Posts |
Posted - 2010-04-23 : 03:35:49
|
| SET DATEFIRST { number } ;For your referenceDAY NAME NUMBERMonday 1Tuesday 2Wednesday 3Thursday 4Friday 5Saturday 6Sunday 7 (default) |
|
|
|
|
|
|
week starting from a specific day of week.