Overflow error
When I run a query without filtering dates it runs fine -
select
*
from MCKSQL21.OS_PRC_CHG_HIST.dbo.V_COST_CHG
But I am receiving an overflow error when I run this query
select
*
from MCKSQL21.OS_PRC_CHG_HIST.dbo.V_COST_CHG
where DITM_EFCTV_DATE
>'2099/01/01'
Msg 517, Level 16, State 1, Line 1
Adding a value to a 'datetime' column caused overflow.
Does anyone know why and how this could be happening?
KDW
October 30th, 2010 11:48am
At a guess it is the format oyour date
Does this solve?
*
from MCKSQL21.OS_PRC_CHG_HIST.dbo.V_COST_CHG
where DITM_EFCTV_DATE
>'2099-01-01'
For the record this is the SQL Server Reporting Services forum so questions here tend to be more to
do with the SSRS functionality rather than SQL queries
selectRgds Geoff
Free Windows Admin Tool Kit Click here and download it now
October 31st, 2010 8:51pm