Arithmetic overflow

Hi,

Every time a run a query where dates are included, I get an 'Arithmetic
overflow error converting expression to data type datetime'.

The dates are stored as yyyymmdd (nvarchar and usually the 'month(DATE_X)
AS Month' syntax is used.

I think that somehow, some of the dates are corrupted.

How can I found out which of then are corrupted? There're too many to scroll
through.

TIA,

Ana


--
*******************************************************************************
"Eres dueño de lo que callas y esclavo de lo que dices"
"Judge your success by what you had to give up in order to get it"
*******************************************************************************

On Tue, 28 Sep 2004 23:22:39 +0200, Ana wrote:

 >The dates are stored as yyyymmdd (nvarchar and usually the 'month(DATE_X)
 >AS Month' syntax is used.
 >
 >I think that somehow, some of the dates are corrupted.
 >
 >How can I found out which of then are corrupted?

Hi Ana,

SELECT YourDateCol
FROM YourTable
WHERE ISDATE(YourDateCol) = 0

And change your database design: use the datetime format to store dates
instead. <g>

Best, Hugo
--

(Remove _NO_ and _SPAM_ to get my e-mail address)