Oninit cdi / Archive
Talk to an expert →

RE: convert value of 'connected' from syssessions

Posted in 1997

"Peter Wang" — — source: Informix-list mailing list archive (1991-1998)

The stored procedure that Partha has mentioned is probably: l2date (long = to date) which returns only date not time. More to this, it returns wrong = date (1 day earlier) as it takes base date as 1969-12-31 instead of = 1970-01-01. I think I will create my own stored procedure. Cheers. Peter Wang ___________________________________________________________________________= ____ From: Partha Dutta on Wed, 30 Apr 1997 12:08 AM Subject: Re: convert value of 'connected' from syssessions To: informix-list@rmy.emory.edu I believe that there is a stored procedure in the sysmaster database that will convert these values to a date (I don't remember what the name is)... Partha Dutta pdutta@airmail.net "Peter Wang" <peter_wang@yes.optus.com.au> wrote in article <5k4ckv$2um@cssun.mathcs.emory.edu>... } Hi all, } } Has anyone tried to convert the value of column 'connected' in table =3D } syssessions (sysmaster database) into more meaningful date time format = in =3D } a SQL statement? } } For example: } } 862295401 -> 1997-04-29 15:33:42 (something like that) } (It seems that the integer value represents seconds from 1970-01-01 =3D } 00:00:00) } } Any tips are appreciated. } } Cheers. Peter } ------------------ RFC822 Header Follows ------------------ }Received: by yes.optus.com.au with SMTP;30 Apr 1997 00:08:33 +1000 }Received: from happy (firewall-user@happy.optus.com.au [203.13.126.9]) by = }news.optus.com.au (8.8.3/8.8.3) with ESMTP id AAA09340 for = }<peter_wang@yes.optus.com.au>; Wed, 30 Apr 1997 00:04:20 +1000 }Received: by happy; id AAA29743; Wed, 30 Apr 1997 00:06:02 +1000 (EST) }Received: from rmy.rmy.emory.edu(170.140.97.4) by happy.optus.com.au via = }smap (3.2) } id xma029739; Wed, 30 Apr 97 00:05:55 +1000 }Received: (from ilist@localhost) by rmy.rmy.emory.edu (8.7.1/8.7.1) id = }IAA21770 for informix-list-out; Tue, 29 Apr 1997 08:05:01 -0400 (EDT) }From: "Partha Dutta" <pdutta@airmail.net> }Message-Id: = }<E159C2D536A7E98A.63611B2CA14B2C78.2B0D38399453853A@library-proxy.airnews.n= }et> }Subject: Re: convert value of 'connected' from syssessions }Date: 29 Apr 1997 11:20:00 GMT }Reply-To: "Partha Dutta" <pdutta@airmail.net> }Organization: INTERNET AMERICA }Sender: informix-list-owner@rmy.emory.edu }To: informix-list@rmy.emory.edu }X-Informix-List-Id: <news.37258>

Related threads