how to get the system date of the server

[haibals]

I developed one application in Vb. Back end is SQL

Server. Many users can access that application which is

sitting in Server. In that application for each

record created i am updating the current date in the

DB. my problem is I want to take the current date

from the server and want to update that. b'cos each

user system can have different dates. i want to rely

only on the date on the server and i will consider what

ever date in the Server will be the Current date.


how can i fetch the date from the server through vb

program.. can you please help me in any way?

[eer3]

Use the sql statement "Select GetDate() from Mytable"

[haibals]

got the mail reg. how to get System date of the server.
I have not yet used that.

once i successfully implemented that, i will let you know.

thanks
bala