开发者

Sybase - way to get time since ASE started?

Is there a way on Sybase ASE开发者_StackOverflow中文版 to get the time since the ASE server was started?


There is a global variable @@boottime which can be used to find the time when the ASE server was started. Simply use -

select @@boottime to get the time when the server was started.


Are you talking about ASE server uptime; if yes, then probably you can find so using the query

select crdate from master..sysdatabases where name = 'tempdb'

which will return the boot time, as tempdb is recreated at boot.

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜