Re: DATETIME

Posted in 1998

John S. Michael — Fri, 13 Feb 1998 13:17:19 -0700 — source: Informix-list mailing list archive (1991-1998)

>let's say my table T contains an attribute A (datatype is DATETIME). > > SELECT A FROM T> >shows the values of A as "yyyy-mm-dd hh.mm.ss" but I just want to see "hh.mm". > >How can I do this?? SELECT extend(A, hour to minute) doesn't work. Specify the column label for the EXTEND function: SELECT EXTEND(A, HOUR TO MINUTE) temp_time FROM ...