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.
精彩评论