Getting the remote system Date !!!!

[senthilvelm]

heloo all!!
am connecting to a remote machine where in my daatabase lies,
is there any way to get the connected system's date???
any active-x control which can do this???or can it eb done by an api???
.,,,
senthil

[sudhir]

hi,
doesn't ur database give that ...
if oracle then
select sysdate from dual ...
otherwise one of the solution is create activex-exe component and port it at that computer ...just as simple as that ...

[senthilvelm]

hi
yes sudhir oracl edoes give that ,
but my MS Access db does not get me that ,
also am not allowed to mount my Active-x componet in the remote systems, so how can i get it ???
any API must be used??

[sudhir]

in access:
select date() from table1

table1 can be any table...

[senthilvelm]

sudhir
i used the method yu said just now...
welll, i tried with a queryded in th eremote system where my access db is there..i selected the now(),
but this gives only local system time and date
any other method????
or any other api ???
thanks in advance
,,,,
senthil