Talk About Network

Google


Register and Login
Nick
Password
Register create new account Sign up is FREE and you can post replies, new topics, bookmark posts and more!
Recover lost password


Software > Access ODBC Client Server > Getting System ...
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 1 of 10 Topic 1408 of 1511
Post > Topic >>

Getting System Time From SQL Server

by "Neil" <nospam@[EMAIL PROTECTED] > Nov 28, 2007 at 02:30 PM

I'm using an Access MDB as a front end to a SQL 7 database. When I place
the 
system time in a field in Access, it used the user's clock. I'd like to
use 
the SQL Server system time, so that the times will be synchronized. I 
suppose I can just do a pass-through query with "select getdate()." But I 
was wondering if there was some built-in method, either in Access or SQL 
Server. I'm concerned about the overhead of running a pass-through query 
every time I need the current time.

Thanks.
 




 10 Posts in Topic:
Getting System Time From SQL Server
"Neil" <nosp  2007-11-28 14:30:04 
Re: Getting System Time From SQL Server
Erland Sommarskog <esq  2007-11-28 22:23:33 
Re: Getting System Time From SQL Server
"Neil" <nosp  2007-11-29 13:46:25 
Re: Getting System Time From SQL Server
"Tony Toews [MVP]&qu  2007-11-29 19:04:30 
Re: Getting System Time From SQL Server
"Neil" <nosp  2007-11-29 20:45:43 
Re: Getting System Time From SQL Server
"Tony Toews [MVP]&qu  2007-11-30 00:30:54 
Re: Getting System Time From SQL Server
"Tony Toews [MVP]&qu  2007-11-29 23:34:00 
Re: Getting System Time From SQL Server
"Pieter Wijnen"  2007-11-30 08:20:21 
Re: Getting System Time From SQL Server
"Neil" <nosp  2007-11-30 13:07:16 
Re: Getting System Time From SQL Server
"Greg D. Moore \(Str  2007-11-30 16:02:34 

Post A Reply:
  Go here to Signup

AddThis Feed Button


About - Advertising - Contact - Frequently Asked Questions - Privacy Policy - Terms of Use - Signup

Contact
tan12V112 Sat Nov 22 1:09:19 CST 2008.