On Fri, Sep 7, 2012 at 9:46 AM, Ls Cheng <exriscer@xxxxxxxxx> wrote: > btw (cast(end_interval_time as date) - cast(begin_interval_time as date)) > * 24 * 3600 is (cast(end_interval_time as date) - > cast(begin_interval_time as date)) * 24 * 60 > > -- //www.freelists.org/webpage/oracle-l