Originally Posted by robiverson

when i query extend(current hour to minute - 40 units minute) i get 2008-12-26 13:31:00.000?
how do i get the value in hhmm format ?. for ex 1331