Hello folks,

I am working on a program on this system where a few computer connect to a MS SQL server and record certain events.

Thing is, I need to log the events with a time stamp so I'll need to find the server clock somehow and access time is vital.

How do I do that?

I program in VB6.

Thanks
Chen

In SQL Server, use the GetDate() function.

-PatP

Yes,
But how do I use it?

I can't just do a -

dim a as string

a=select getdate()

or whatever..

Just SELECT it (using ADO) like you would any other date.

-PatP

Let's say I usually select things into a recordset.

How would I call that field in the recordset results?