Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

week 33 is week 34 1

Status
Not open for further replies.
AtomicWedgie

AtomicWedgie

IS-IT--Management
Jul 10, 2002
227
NL
Hi,

it is now week 33, but when I ask for the week in SQL it gives week 34.

How can I solve this?

First day of the week is Sunday at the moment.

Regards,

Atomic Wedgie
 
Sort by date Sort by votes
Could it be that SQL considers the 1st of January a 'one day week'? You've set the week to begin on Sunday, but 1 January was a Saturday....

-SQLBill

Posting advice: FAQ481-4875
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Steve Yu
  • Locked
  • Question
How secure is MS SQL on the Internet vs behind firewall inside a LAN 1
Replies
3
Views
625
Chris Miller
Chris Miller
grnzbra
  • Locked
  • Question
Is "IF EXISTS()..." better than "IF (SELECT COUNT...) > 0"
Replies
4
Views
3K
gmmastros
gmmastros
ahmedsa2018
  • Locked
  • Question
the goal mfrom asking question is t
Replies
0
Views
249
ahmedsa2018
ahmedsa2018
peac3
  • Locked
  • Question
Gaps and islands
Replies
8
Views
636
Chris Miller
Chris Miller
ahmedsa2018
  • Locked
  • Question
How to add column columnunit dynamically when FlagAllow is 1?
Replies
0
Views
182
ahmedsa2018
ahmedsa2018

Part and Inventory Search

Sponsor

Back
Top