Error :Arithmetic overflow occurred

[Zeliha]

I have two tables which have dates in varchar fields on both. I have to
join them to get the data . I wrote the following syntax in where clause. In
one of the fields includes time and the other does not. But the thing is, I
got the Arithmetic overflow occurred error message after '01/01/2000'. Isn't
it strange?

convert(varchar(30),convert(datetime,R.request_dat e),101)=convert(varchar(30
),convert(datetime,B.request_date),101)

[Colin Leversuch-Roberts]

I suspect you might have a date that doesn't evaluate from a string to a date.


------------
Zeliha at 2/7/00 6:08:48 AM

I have two tables which have dates in varchar fields on both. I have to
join them to get the data . I wrote the following syntax in where clause. In
one of the fields includes time and the other does not. But the thing is, I
got the Arithmetic overflow occurred error message after '01/01/2000'. Isn't
it strange?

convert(varchar(30),convert(datetime,R.request_dat e),101)=convert(varchar(30
),convert(datetime,B.request_date),101)

[Zeliha]

Do you have an idea that how I can find the data that causes the error?
Even I got the following error, I got the correct data from the query.
Thanks,
Zeliha

------------
Colin Leversuch-Roberts at 2/7/00 7:40:01 AM

I suspect you might have a date that doesn't evaluate from a string to a date.


------------
Zeliha at 2/7/00 6:08:48 AM

I have two tables which have dates in varchar fields on both. I have to
join them to get the data . I wrote the following syntax in where clause. In
one of the fields includes time and the other does not. But the thing is, I
got the Arithmetic overflow occurred error message after '01/01/2000'. Isn't
it strange?

convert(varchar(30),convert(datetime,R.request_dat e),101)=convert(varchar(30
),convert(datetime,B.request_date),101)