1 Reply Latest reply: Apr 11, 2012 7:17 AM by Stefan Wühl RSS

    intervalmatch and time interval (rounding problem?)

    Henry Rolofs

      Hello together,

       

      i have some problems with the intervalmatch function. I have load a table with the interval boundaries. This are time intervals. Here you can see as an example of two of thie entries.

       

      0 - 15 minutes        00:00:00 (0)                    00:14:59 (0.010405092592593)

      15 - 30 minutes       00:15:00 (0.010416666666667)    00:29:59 (0.020821759259259)

       

      Then i have a table with start time and stop times and a calcualtes duration between start and stop.

       

      You can see that the Entries 1-4 matched, the entries 5-9 and 10-13 dosn't matched and 14-19 matched.

       

      1   0 - 15 minutes    2010-10-07 10:34:22 2010-10-07 10:49:21 (14:59) 0.010405092587462

      2   0 - 15 minutes    2010-06-06 07:07:58 2010-06-06 07:22:57 (14.59) 0.010405092587462

      3   0 - 15 minutes    2010-05-27 22:55:31 2010-05-27 23:10:30 (14:49) 0.010405092587462

      4   0 - 15 minutes    2010-04-21 07:02:00 2010-04-21 07:16:59 (14:59) 0.010405092587462

      5                     2012-03-02 12:49:34 2012-03-02 13:04:33 (14:59) 0.010405092594738

      6                     2012-03-05 11:09:47 2012-03-05 11:24:46 (14:59) 0.010405092594738

      7                     2012-03-09 12:20:15 2012-03-09 12:35:14 (14:59) 0.010405092594738

      8                     2012-02-01 20:24:56 2012-02-01 20:39:55 (14:59) 0.010405092594738

      9                     2012-02-02 13:10:26 2012-02-02 13:25:25 (14:59) 0.010405092594738

       

      ...

       

      10                    2010-08-04 14:52:12 2010-08-04 15:07:12 (15:00) 0.010416666664241

      11                    2010-08-20 11:20:37 2010-08-20 11:35:37 (15:00) 0.010416666664241

      12                    2010-05-21 09:37:28 2010-05-21 09:52:28 (15:00) 0.010416666664241

      13                    2010-04-28 18:07:00 2010-04-28 18:22:00 (15:00) 0.010416666664241

      14  15 - 30 minutes   2012-03-10 09:07:31 2012-03-10 09:22:31 (15:00) 0.010416666671517

      15  15 - 30 minutes   2012-03-12 10:39:08 2012-03-12 10:54:08 (15:00) 0.010416666671517

      16  15 - 30 minutes   2012-03-27 07:43:31 2012-03-27 07:58:31 (15:00) 0.010416666671517

      17  15 - 30 minutes   2012-02-12 11:47:13 2012-02-12 12:02:13 (15:00) 0.010416666671517

      18  15 - 30 minutes   2012-02-13 11:12:18 2012-02-13 11:27:18 (15.00) 0.010416666671517

      19  15 - 30 minutes   2012-02-20 12:28:05 2012-02-20 12:43:05 (15:00) 0.010416666671517

       

      I think the problem is the internal presentation of time values. Not as an internder (seconds), as an part of a day (1 s = 1/864000).

       

      If there any possibility to change the behavier of the intervalmatch function?

       

      Regards, Henry