CODEWITHSUNDEEP
sap-ase
hawkeye
hawkeye

Reputation: 35732

Sybase - way to get time since ASE started?

Is there a way on Sybase ASE to get the time since the ASE server was started?

Upvotes: 3

Views: 9795

Answers (2)

Neo
Neo

Reputation: 142

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.

Upvotes: 5

Rahul
Rahul

Reputation: 77896

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.

Upvotes: 1

Related Questions