RE: sql date select statement HP-UX

Posted in 1998

Leffler, Jonathan — Fri, 17 Apr 1998 10:34:03 -0700 — source: Informix-list mailing list archive (1991-1998)

SELECT DATETIME(1970-01-01 00:00:00) YEAR TO SECOND + unixtimecol UNITS SECOND FROM WhichEverTable; That assumes you accept DATETIME as being human readable - I do. Yours succinctly, Jonathan Leffler (jleffler@visa.com) #include <bother.ms-exchange.h> ---------- From: Art Eldred[SMTP:art@unrrts.com] Sent: Friday, April 17, 1998 7:08 AM Does anyone know how to convert UNIX based time (number of seconds from UNIX birth) to a human readable format from a sql select statement? Help!!