SA10.0.1.3784
Windows Server 2003
Windows XP Pro

I've searched the online documentation and was unable to find
anything.

Is there a database server property that can be queried that indicates
how long the database has been up and running?

Thanks

Scott Huerta
3i Infotech (formerly Distinctive Solutions Corp.)

The following should do it:
select property('StartTime')
You can convert the resulting string to a timestamp and use the datediff()
function to calculate an uptime.
select datediff(second,property('StartTime'),current timestamp)

SQL Anywhere Developer Community:
http://www.sybase.com/developer/libr...ere-techcorner


SQL Anywhere Blog Center: http://www.sybase.com/sqlanyblogs




Scott Huerta wrote:

Perfect!

Thank you.

On 15 Jan 2010 09:24:17 -0800, Bruce Hay
<h_a_y_@_i_a_n_y_w_h_e_r_e_d_o_t_c_o_m> wrote:

Scott Huerta
3i Infotech (formerly Distinctive Solutions Corp.)