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...
-
If DCOB Fault comes on your main phone this means that there is no external lines available and you will need to call you service pro... -
Crystal Reports datepart is slightly different than SQL and VB Interval type Description yyyy Extr...
-
Today, emergencies happen often. Below is a list of emergency supplies that you should have available. This list is not made in stone. For...
No comments:
Post a Comment