Re: convert value of 'connected' from syssessions

Posted in 1997

Partha Dutta — 29 Apr 1997 11:20:00 GMT — source: Informix-list mailing list archive (1991-1998)

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 = > syssessions (sysmaster database) into more meaningful date time format in = > 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 = > 00:00:00) > > Any tips are appreciated. > > Cheers. Peter >