如何获得“服务器”的时间

[caoyanqi1981]

开发网络版的软件时，怎样才能获得服务器的时间？

[xjbs]

function

gf_GetServerDateTime
{
DateTime ldtServerDateTime
Select top 1 GetDate() Into :ldtServerDateTime From Table1
return ldtServerDateTime
}

....
table1自已任建一个表就行了，
再向里面写一条记录即可，，

[runsoft]

select distinct getdate() from sysobjects

[YewPu]

用存储过程.

[pbaihaozhe9]

清风的就可以。

[eminena]

在 PB 中:

datetime sysdt

select distinct getdate() into :sysdt from sysobjects

[workhand]

CREATE PROCEDURE sp_getdate
@dt datetime output
AS
set @dt = getdate()

[eastpond]

结帖

[duttian]

做个函数分f_getsystime()


string ls_sql
datetime sysdate
declare lc_dept dynamic cursor for sqlsa;

ls_sql = "select getdate()"
prepare sqlsa from :ls_sql;

open dynamic lc_dept;

if sqlca.sqlcode = 0 then
fetch lc_dept into :sysdate;
else
sysdate=datetime(Date("1900/01/01"))

end if
close lc_dept;
return sysdate

[chenqinzeng]

getdate()

[jdsnhan]

oracle 中
datetime server_system_time
select sysdate
into :server_system_time
from sys.dual;