re: Automatic rounding in INTERVAL calculations

2002-10-22 Thread Victoria Reznichenko
andrew, Monday, October 21, 2002, 8:53:15 PM, you wrote: aatdc> Description: aatdc> When attempting to select rows periodically (as in scheduling) the aatdc> INTERVAL function will round the parts of an expression before doing aatdc> the calculation of the expression. F

Automatic rounding in INTERVAL calculations

2002-10-21 Thread andrew
>Description: When attempting to select rows periodically (as in scheduling) the INTERVAL function will round the parts of an expression before doing the calculation of the expression. For example: now() - INTERVAL 0.1*60 MINUTE == now() The correc