Arithmetic overflow error converting expression to data type datetime.

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 7,2000 » T-SQL » Arithmetic overflow error converting...

Arithmetic overflow error converting expression to data type datetime.

Rate Topic

Display Mode

Topic Options

Author

Message

pavargasq

Posted Sunday, December 05, 2010 5:50 PM

SSC Rookie

Group: General Forum Members
Last Login: Saturday, December 08, 2012 8:24 PM
Points: 40, Visits: 135

good evening:

i have a huge table tin sql 2000 and it has 1148052581

when i use select o select count_big(*) command it yields an error:

select count_big(*) from HECHOS_MOVTO_PREPAGO_ACTUACIONES

where FEC_ACTUALIZACION >= 20090201 and FEC_ACTUALIZACION <= 20091231

Arithmetic overflow error converting expression to data type datetime.

how can i handle this error and execute the query without any eroor?

id appreciate your help

Post #1030412

Jeff Moden

Posted Sunday, December 05, 2010 5:56 PM

SSC-Dedicated

Group: General Forum Members
Last Login: Yesterday @ 8:21 PM
Points: 32,893, Visits: 26,765

Single Quotes...

select count_big(*) from HECHOS_MOVTO_PREPAGO_ACTUACIONES
where FEC_ACTUALIZACION >= '20090201' and FEC_ACTUALIZACION <= '20091231'

--Jeff Moden

"RBAR is pronounced "ree-bar" and is a "Modenism" for "Row-By-Agonizing-Row".

First step towards the paradigm shift of writing Set Based code:
Stop thinking about what you want to do to a row... think, instead, of what you want to do to a column."

For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/

For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

Post #1030414

Steve Jones - SSC Editor

Posted Sunday, December 05, 2010 6:04 PM

SSC-Dedicated

Group: Administrators
Last Login: 2 days ago @ 1:47 PM
Points: 31,406, Visits: 13,722

You are getting an implicit conversion, expecting SQL Server to convert those integer values for you. As Jeff mentioned, you want to use quotes around dates to explicitly state the values are dates and not numbers.

Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help

Post #1030418

Jeff Moden

Posted Monday, December 06, 2010 8:28 PM

SSC-Dedicated

Group: General Forum Members
Last Login: Yesterday @ 8:21 PM
Points: 32,893, Visits: 26,765

pavargasq (12/5/2010)

id appreciate your help

Heh... we'd appreciate a little feedback. Wink

Did that fix it for you or not?

--Jeff Moden

Post #1030977

« Prev Topic | Next Topic »

Permissions