Internal Time Conversion
Posted in 1997
Jeff Diaz — — source: Informix-list mailing list archive (1991-1998)
I am trying to create an SQL script to tell how long users are logged in to our system. To do this, I was intending to use the connected field of the syssessions table. This field appears to store the internal datetime format for the time the user connected to the database. Is there a way to convert this integer into a format that resembles a time? Is this possible? I've done this before on other systems, but I can't figure our what I had done before, or if Informix can do it. Is this a possibility, or is there a better way? Thanks Jeff Diaz jdiaz@accustaff.com