| View previous topic :: View next topic |
| Author |
Message |
Simon Yeung Guest
|
Posted: Wed Jul 28, 2004 7:27 am Post subject: How to get a server's time |
|
|
I want to ask, haven't any method to get SQL server's time?
I know how to get a client computer's time by type command "now", but how to
get the SQL server's time.
thank for your attention.
|
|
| Back to top |
|
 |
Florian Teichert Guest
|
Posted: Wed Jul 28, 2004 7:59 am Post subject: Re: How to get a server's time |
|
|
Simon Yeung schrieb:
| Quote: | I want to ask, haven't any method to get SQL server's time?
|
.... assuming that you are using MS-SQL Server: try "getdate()"
| Quote: | thank for your attention.
|
.... you are welcome
|
|
| Back to top |
|
 |
Simon Yeung Guest
|
Posted: Wed Jul 28, 2004 8:55 am Post subject: Re: How to get a server's time |
|
|
Thx..
"Florian Teichert" <floteichNO (AT) SPAMhrzpub (DOT) NOBOTtu-darmstadtUURGH.de> ¦b¶l¥ó
news:41075cba$1 (AT) newsgroups (DOT) borland.com ¤¤¼¶¼g...
| Quote: |
Simon Yeung schrieb:
I want to ask, haven't any method to get SQL server's time?
... assuming that you are using MS-SQL Server: try "getdate()"
thank for your attention.
... you are welcome
|
|
|
| Back to top |
|
 |
|