How to get remote server datetime

#1

Hi All ,
I have 3 sql servers located at different time zones. Say, CST,PST,EST.
Now how can I get current time at EST,PST from the SQL server located
at CST? Is there any query to do that?

I have a stored proc located in SQL server at CST zone where I need to
query for the current date/time of the other zone sql servers.

I tried below query at CST SQL server
SELECT TOP 1 GETDATE() FROM [SERVER-PST].master.dbo.syslocks

But it always gives CST datetime.

Please reply...

Thanks
RP

#2

Haven't tested but it should work using Openquery instead of
the 4 part name. The statement passed in the openquery is
executed on the remote server.

-Sue

On Fri, 27 Apr 2007 12:24:01 -0700, Ram
<Ram (AT) discussions (DOT) microsoft.com> wrote:

Quote:

Hi All ,
I have 3 sql servers located at different time zones. Say, CST,PST,EST.
Now how can I get current time at EST,PST from the SQL server located
at CST? Is there any query to do that?

I have a stored proc located in SQL server at CST zone where I need to
query for the current date/time of the other zone sql servers.

I tried below query at CST SQL server
SELECT TOP 1 GETDATE() FROM [SERVER-PST].master.dbo.syslocks

But it always gives CST datetime.

Please reply...

Thanks
RP

#3

Hi Sue,
It works gr8....

Thanks for the help...

"Sue Hoegemeier" wrote:

Quote:

Haven't tested but it should work using Openquery instead of
the 4 part name. The statement passed in the openquery is
executed on the remote server.

-Sue

On Fri, 27 Apr 2007 12:24:01 -0700, Ram
Ram (AT) discussions (DOT) microsoft.com> wrote:

Hi All ,
I have 3 sql servers located at different time zones. Say, CST,PST,EST.
Now how can I get current time at EST,PST from the SQL server located
at CST? Is there any query to do that?

I have a stored proc located in SQL server at CST zone where I need to
query for the current date/time of the other zone sql servers.

I tried below query at CST SQL server
SELECT TOP 1 GETDATE() FROM [SERVER-PST].master.dbo.syslocks

But it always gives CST datetime.

Please reply...

Thanks
RP

#4

Hi,
Can you please write the exact syntax you used for Openquery? I also have
requirement similar to this.
Thanks for your help.
Namwar

"Ram" wrote:

Quote:

Hi Sue,
It works gr8....

Thanks for the help...

"Sue Hoegemeier" wrote:

Haven't tested but it should work using Openquery instead of
the 4 part name. The statement passed in the openquery is
executed on the remote server.

-Sue

On Fri, 27 Apr 2007 12:24:01 -0700, Ram
Ram (AT) discussions (DOT) microsoft.com> wrote:

Hi All ,
I have 3 sql servers located at different time zones. Say, CST,PST,EST.
Now how can I get current time at EST,PST from the SQL server located
at CST? Is there any query to do that?

I have a stored proc located in SQL server at CST zone where I need to
query for the current date/time of the other zone sql servers.

I tried below query at CST SQL server
SELECT TOP 1 GETDATE() FROM [SERVER-PST].master.dbo.syslocks

But it always gives CST datetime.

Please reply...

Thanks
RP

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

How to get remote server datetime

microsoft.public.sqlserver.clients microsoft.public.sqlserver.clients

How to get remote server datetime - 04-27-2007 , 02:24 PM

Re: How to get remote server datetime - 04-29-2007 , 06:36 PM

Re: How to get remote server datetime - 04-30-2007 , 10:24 AM

Re: How to get remote server datetime - 08-07-2007 , 10:40 AM