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)
-
Crystal Reports datepart is slightly different than SQL and VB Interval type Description yyyy Extr...
-
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... -
Do you charge your device in a public or on a non secure work space ? if the answer is yes then you are leaving your device open to be hac...
No comments:
Post a Comment