3 ms·
Oh wow, insane is the right word for that. (Once long ago in my youth, I got bitten when the quoting app I was writing worked fine on our test server, but got
by taneq 10y ago
Oh wow, insane is the right word for that.
(Once long ago in my youth, I got bitten when the quoting app I was writing worked fine on our test server, but got the day and month fields swapped on our customer's server. And that was when I learned that you shouldn't pass dates through ODBC as text strings...
SQL Server was parsing dates based on the Windows date settings. Our test server was set to the default U.S. date format but the customer's server was set to DD/MM/YY, or vice versa, I can't remember now. What made it worse was that we handed the system over early in a month, and it worked fine for over a week...)