l2datetime stored procedure needed

Posted in 1998

Milen Metodiev — Fri, 18 Dec 1998 11:58:32 +0200 — source: Informix-list mailing list archive (1991-1998)

Hi, I would like to have a sorted list of users by connection time. In syssessions table there is a 'connected' column which is the one I need. But, I have only 'l2date' stored procedure which returns date type. Is there stored procedure 'l2datetime' or something to convert 'connected' column in syssessions table to datetime type? Thank you, Milen.