how do you get boot date/time from sql?

Hi, Is there a select that will return the Informix engine boot time in a datetime format? If so, is there also a select which will return the current "uptime" of the server? We are currently running IDS 7.31.UC5. Thanks in advance! Rick * Sent from RemarQ http://www.remarq.com The Internet's Discussion Network * The fastest and easiest way to search and participate in Usenet - Free!

Check out the sysshmvals table in sysmaster Rick wrote: > > Hi, > > Is there a select that will return the Informix engine boot time > in a datetime format? > > If so, is there also a select which will return the current > "uptime" of the server? > > We are currently running IDS 7.31.UC5. > > Thanks in advance! > > Rick > > * Sent from RemarQ http://www.remarq.com The Internet's Discussion Network * > The fastest and easiest way to search and participate in Usenet - Free! -- Paul Watson # WF Software Ltd # You are only young once Tel: +44 1436 674729 # but you can be immature Fax: +44 1436 678693 # for ever www.wfsoftware.com #

I've noticed the values are stored as 'int'. How would I convert them to a valid datetime field in my timezone? * Sent from RemarQ http://www.remarq.com The Internet's Discussion Network * The fastest and easiest way to search and participate in Usenet - Free!

Rick wrote: > I've noticed the values are stored as 'int'. How would I > convert them to a valid datetime field in my timezone? If the 'int' column is BootTime, then: SELECT DATETIME(1970-01-01 00:00:00) YEAR TO SECOND + BootTime UNITS SECOND FROM WhereEver; -- Jonathan Leffler (jleffler@informix.com, jleffler@earthlink.net) Guardian of DBD::Informix v0.95 -- see http://www.perl.com/CPAN #include <disclaimer.h>

Thanks John. Is there a simple way to convert it to Eastern standard time? Rick * Sent from RemarQ http://www.remarq.com The Internet's Discussion Network * The fastest and easiest way to search and participate in Usenet - Free!