Re: convert 'connected' to a datetime

Posted in 1998

Jonathan Leffler — Wed, 23 Sep 1998 09:17:22 -0700 (PDT) — source: Informix-list mailing list archive (1991-1998)

On Wed, 23 Sep 1998, Nicole Guffey wrote: > I need to convert sysmaster.syssessions.connected from integer to datetime > year to second. Does anyone know how this can be done, or another way to > determine the datetime year to second that a connection was established? SELECT DATETIME(1970-01-01 00:00:00) YEAR TO SECOND + S.Connected UNITS SECOND FROM sysmaster:'informix'.SysSessions S; Yours, Jonathan Leffler (jleffler@informix.com) #include <witticism.h> Guardian of DBD::Informix v0.60 -- http://www.perl.com/CPAN Informix IDN for D4GL & Linux -- http://www.informix.com/idn