Posted by Neil on 11/28/07 20:30

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.

• Next in forum: Re: many "or" operation make system choose incorrect index
• Prev in forum: Distinct Name with Date Order By Date
• Thread view: Getting System Time From SQL Server

[Reply to this message]