Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 Transact-SQL (2000)
 Select time from Server

Author  Topic 

ilimax
Posting Yak Master

164 Posts

Posted - 2004-11-12 : 16:51:11
Does anybody know how I can get timer from the server in my client application ....???

robvolk
Most Valuable Yak

15732 Posts

Posted - 2004-11-12 : 16:54:58
Select getdate()

That will give you the current date and time on the server. You can parse the output to get just the time.
Go to Top of Page

Seventhnight
Master Smack Fu Yak Hacker

2878 Posts

Posted - 2004-11-12 : 16:55:41
timer?? this what you mean?

--wait 5 secs then do something
waitfor DELAY '00:00:05'
Select 'hi'

Corey
Go to Top of Page
   

- Advertisement -