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.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2005-06-14 : 07:39:24
|
| Choong Foong writes "I am trying to use SQL to obtain the Database Server SQL Server's system datetime remotel from a client pc through the network.I have tried to use the ADO Command and execute a "SELECT GETDATE()" command but failed with -1 on the execution result.Thanks to anyone who can help me.I am trying to get the datetime and overwrite the local client pc's datetime so can synchornize the system time Thanks" |
|
|
JimL
SQL Slinging Yak Ranger
1537 Posts |
Posted - 2005-06-14 : 07:48:23
|
| I do not understand SELECT GETDATE()will return the servers date/timewhat Are You using for a front end?JimUsers <> Logic |
 |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2005-06-14 : 07:53:27
|
| Did you use this in your Front end application?If so,Post the code you used Did you try to assign that result to any variable of different datatype?MadhivananFailing to plan is Planning to fail |
|
|
|
|
|
|
How to Get System DateTime from Client?