Subject AW: [firebird-support] Round - quarter hour
Author checkmail
Post date 2014-04-08T05:54:08Z

First example:

 

      timediff = mod(minutestoround,15);

      if(15/2 < timediff) then

      roundedminutes = minutestoround + 15 - timediff;

      else

      roundedminutes = minutestoround - timediff;

 

?

 

Von: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com] Im Auftrag von checkmail
Gesendet: Dienstag, 8. April 2014 07:39
An: firebird-support@yahoogroups.com
Betreff: [firebird-support] Round - quarter hour

 

 

Hello,

 

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.

 

Regards

 

Olaf