Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
deirdre
Starting Member
1 Post |
 Posted - 2006-11-30 : 18:39:02
|
| We run a regular query through Excel that is linked to a Microsoft SQL Server data source. We have run this query routinely for the past few years. Suddenly this query has started returning an error message - “[Microsoft][ODBC SQL Server Driver] [SQL Server] Difference of two datetime columns caused overflow at runtime”. It seems to be a common error (as per Google search) however I don’t want to go messing around with something I don’t fully understand. Can anyone point me in the direction of what to look out for? |
|
|
ditch
Master Smack Fu Yak Hacker
1466 Posts |
Posted - 2006-12-01 : 00:21:00
|
Datetime fields often cause problems when SQL does not know what value represents the Year and what value represents the month and what value represents the day.What I find is generally pretty safe is - making all Dates in the xls spreadsheet YYYY-MM-DD format.Duane.  |
 |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2006-12-01 : 03:09:14
|
| or YYYYMMDD formatMadhivananFailing to plan is Planning to fail |
|
|
|
|
|
|
overflow at runtime