|Subject||AW: [firebird-support] Round - quarter hour|
timediff = mod(minutestoround,15);
if(15/2 < timediff) then
roundedminutes = minutestoround + 15 - timediff;
roundedminutes = minutestoround - timediff;
in my Case I would round a integer number to a full quarter number: 12 to 15, 91 to 90, 98 to 105 etc.
Is there anything I can use?
Thanks a lot.