Adaptive Server Anywhere Server Version 9.0.2.3951 How do I get the date time that the database was started? Via sql command / function or something.

asked 27 Sep '13, 14:21

Walmir%20Taques's gravatar image

Walmir Taques
625293144
accept rate: 13%

edited 27 Sep '13, 14:22


SELECT PROPERTY ( 'StartTime' );

PROPERTY('StartTime')
'2013-09-27 15:21:06.152'
permanent link

answered 27 Sep '13, 15:20

Breck%20Carter's gravatar image

Breck Carter
26.2k430600863
accept rate: 20%

3

Note that the property StartTime is when the server was started. There is not an equivalent property for when the database file was started as far as I know.

(27 Sep '13, 15:24) Chris Keating

The SYSHISTORY table should have this information. Look for the LAST_START operation.

permanent link

answered 27 Sep '13, 14:30

Chris%20Keating's gravatar image

Chris Keating
2.9k1650
accept rate: 29%

Ok...thank you!

(27 Sep '13, 14:39) Walmir Taques

Note: SYSHISTORY has been introduced in ASA 9.0.1. Generally, and for older versions, you can also query the according server property via

SELECT property('StartTime');

That's even easier IMHO.

permanent link

answered 27 Sep '13, 15:26

Volker%20Barth's gravatar image

Volker Barth
30.8k308456665
accept rate: 32%

Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:

×12

question asked: 27 Sep '13, 14:21

question was seen: 542 times

last updated: 27 Sep '13, 15:26