Re: ANSWER: expr -> int in ACE select

Posted in 1994

Michael Wiik — Wed, 19 Jan 1994 01:35:24 GMT — source: Informix-list mailing list archive (1991-1998)

mwiik@netcom.com (Michael Wiik) writes: >select year( mdy( 1,1, (tod / 10000 + 1900) ) ) - 1900 r_hour Which is actually my entry for obfuscated ACE code contest :) A more simple and elegant solution, supplied by Cathy Kipp, is select trunc( tod / 10000 ) r_hour Perhaps I can be forgiven as the word "trunc" doesn't appear in my SQL 4.00 reference index (of course, a lot of things don't appear in Informix indexes :) -Mike -- | o==== . : ... : : . |Mail Me Neat Stuff->POB 3703 Arlington VA 22203 --@-- . o o o ... O -O- o o : | mwiik@netcom.com | ... : : |----------------------------------------------- mEssAGE fRoM sPAcE ARt stUdiOs | Stop Global Whining