how do you get boot date/time from sql?
Rick, on IDS 7.31.UC5, asked how to get engine boot time and uptime via SQL. Paul Watson pointed to sysshmvals in sysmaster. Jonathan Leffler gave DATETIME(1970-01-01 00:00:00) YEAR TO SECOND + BootTime UNITS SECOND to convert the integer. Rick's last question, converting to Eastern time, got no answer.
Auto-generated by Claude from the posts below — may be imperfect; read the full thread.
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!