Re: [Help] Current Time

Posted in 1999

ccremid — Mon, 25 Jan 1999 17:28:30 -0800 — source: Informix-list mailing list archive (1991-1998)

Wang Chen wrote: > > We have a DATETIME(YEAR to MINUTE) field A. > Now if I need to retrive all the records with: > > CURRENTTIME - field A < 2 hours try: where column >= current year to minute - 120 unit minutes > > i.e., records just being inserted within last 2 hours. > HTH Tino