to get the getdate() of another server. using linked server.

Hi.
If we have a sqlserver in two different geogriphycal region and if it is connected both the server to linked server. Eg. India and US. if we connect india server to US through linked server. how to get the getdate() of US servers.

Hello,
May I ask what you get back currently and could you also send the query you are issuing?
I would imagine (but can't try at the moment) that if you issue:
SELECT *
FROM OPENQUERY(USLinkedServer, 'SELECT getdate())
GO
... you should get the date of USLinkedServer.
Kind Regards,
Elisabeth

Thank you Elisabeth.
This date statement was striking in mind for a long time. I to dont have an requirement or work environmnet to to test it.