|
|
|
| Title | Valid Access dates may overflow in SQL Server |
|---|
| Keywords | SQL, SQL Server, Access, database, dates, overflow |
|---|
| Categories | Database |
|---|
|
|
|
During a discussion of SQL dates, Andy Winningham pointed out:
Another thing to remember about going from Access to SQL Server regarding data conversion is that a valid date in Access may not be valid in SQL. For example, Access will treat the date 01/01/200 as valid. However if you try and load this date into a SQL Server database, you will get an overflow error.
|
|
