Tuesday, 25 November 2014
Stored procedure skips date
If you are using date math in a stored procedure like datepart(dw,getdate()) which returns a 2 for Tuesday make sure you set the Datefirst parameter to the first day of the week for the country you are in. set DATEFIRST 1. see here
Failure to do this could result in your date calculations not running properly, Tuesday may become 3. This is due to the fact that when run manually the calculation are run differently than when a Job is run from SQL server agent.
Subscribe to:
Post Comments (Atom)
Multi Point USB Charger
USB Plug Charger, 4-Port USB Fast Charger Plug with 33W Intelligent Quick Charge 3.0 Wall Charger, Multi USBPower Adapter UK Fast Charging...
-
USB Plug Charger, 4-Port USB Fast Charger Plug with 33W Intelligent Quick Charge 3.0 Wall Charger, Multi USBPower Adapter UK Fast Charging...
-
Today, emergencies happen often. Below is a list of emergency supplies that you should have available. This list is not made in stone. For...
-
The government want to bring in new laws for dogs that will be difficult to enforce, why do not they just use the ones every ones forgot abo...
No comments:
Post a Comment