December 2, 2005 at 4:24 am
Hi ,
This may be simple!!
In DB2, select * from ifit.revenue where date(changedtimestamp) = '2005-10-05'
gives the output 2 rows.
In SQL Server by using OPENQUERY,
SELECT *
FROM OPENQUERY(IFIT,
'select * from S65824BE.IFIT.REVENUE where date(changedtimestamp)
= ''2005-10-05'''
gives me the output only 1 row. ie., After seeing the record, only first row is being fetched.
For a different date, the same query gives me in DB2 as 47 records and in SQL Server 3 records..
Could anyone update me what could be the issue on this!! Is this because of timestamp ??
Thanks,
Adi
December 21, 2005 at 10:14 pm
Hello All,
This issue has been resolved now.
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply