| |
| |
Input of Date data fails
| Reference Number: AA-00238 Views: 1266 Created: 2010-11-16 13:29 Last Updated: 2011-01-28 10:15 |
0 Rating/ 0 Voters
|
 |
IssueWhen dates are input this produces an error similar to :
Solution When you are working with dates in SQL server use the internationalised ISO date format, which is "YYYYMMDD" (no separators). This type of date will be accepted regardless of the language setting, and therefore will produce predictable results on any SQL server instance. You can find out more about this here: http://support.microsoft.com/kb/173907
|
| |
|
