Re: rounding interval type to nearest 15 minute

Posted in 1996

Douglas Wilson — Wed, 23 Oct 1996 09:23:19 -0700 — source: Informix-list mailing list archive (1991-1998)

Marc Kneppers wrote: > ANyone have an easy way of rounding an interval up or down to the > nearest 15 minute interval? I don't think so. > am I missing something obvious? Convert the interval to a string, parse the string to grab the minutes and convert to an integer so you can round that to whatever you want, then put the modify or reconstruct the string and convert back to an interval. Or am I missing something obvious? > MArc > > -------------------------------------------------------------------------- > Marc Kneppers > System Administrator and Everything-Under-the-Sun-guy > PAMCO > marc@pamco.com > -------------------------------------------------------------------------- > "Kiss my Royal Canadian" -- Sincerly, Doug Wilson(dougw@amgen.com) *** The opinions expressed here are my own and not neccessarily *** *** anyone elses **** *** Disclaimer: These are the opinions of the poster not Amgen Inc.***