The forum will be down for maintenance over the weekend of August 18-20, 2017. The forum will be shut down on the evening (EDT) of Friday, August 18. Downtime is unknown but may be up to two days. The forum will be restarted as soon as maintenance is complete.

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
625293145
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.5k433604876
accept rate: 21%

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.9k309457667
accept rate: 33%

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: 546 times

last updated: 27 Sep '13, 15:26