VB.Net dynamic SQL WHERE DateField = ‘2012-12-13’ converts to US date and possibly throws error if then invalid
14-Dec-1212 Leave a comment
VB.Net dynamic SQL WHERE DateField = ‘2012-12-13’ converts to US date and possibly throws error if then invalid
Was only happening on Windows XP, possiby 32-bit computers.
Windows 7 64-bit were ok.
In this case it was against a view. Solved by changing view:
SELECT ts.JobSheetID
, CAST(js.DateMJSAASdatetime2(0)) AS DateMJSA
,js...
FROM