Re: hour, minute and week functions

T.K. Anand wrote: >Informix has Time functions for YEAR, MONTH, DAY but none for WEEK, HOUR, >MINUTE, SECOND. How does one extract the HOUR out of a datetime column ? > >=TK= > EXTEND(DATETIME(1998-01-01 13:48) YEAR TO MINUTE, HOUR TO HOUR) Hope it helps, Octav -- Octav Chiriac Phone: (373) 2 21 20 96 NetInfo S.R.L. Fax: (373) 2 21 36 59 Chisinau (373) 2 24 00 83 Moldova, Republic of mailto:com@netinfo-moldova.com