Re: Q: DATETIME

Torsten Binias wrote: > Hi there, > 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. > > Many thanks in advance, > Torsten This is not exactly what you are asking for but maybe can help. SELECT (EXTEND(col1, year to minute) - EXTEND(col1,year to day) ) FROM table1 The result will be in "0 hh:mm" format. Hope this helps Tino