--How long as SQL Server been up.
select cast((datediff(hh, crdate, getdate()))/24 as varchar(3)) + ' days and ' + cast((datediff(hh, crdate, getdate())) % 24 as varchar(2)) + ' hours ' + cast((datediff(n, crdate, getdate())) % 60 as varchar(2)) + ' minutes' from master..sysdatabases where name = 'tempdb'
Posts
No comments:
Post a Comment