-
Error :Arithmetic overflow occurred
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)
-
Error :Arithmetic overflow occurred (reply)
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)
-
Error :Arithmetic overflow occurred (reply)
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)
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|