小黑米的生活

日期算法题

浏览次数:

+———————+———————+
| start_time | end_time |
+———————+———————+
| 2010-03-04 00:00:00 | 2010-03-19 00:00:00 |
| 2010-03-04 00:00:00 | 2010-03-20 00:00:00 |
| 2010-03-06 00:00:00 | 2010-03-07 00:00:00 |
| 2010-03-06 07:53:30 | 2010-03-06 07:53:30 |
| 2010-03-06 07:53:58 | 2010-03-06 07:53:58 |
| 2010-03-06 08:11:37 | 2010-03-06 08:11:37 |
| 2010-03-06 08:17:00 | 2010-03-06 08:17:00 |
| 2010-03-06 08:55:04 | 2010-03-31 00:00:00 |
| 2010-03-06 08:55:43 | 2010-03-31 00:00:00 |
| 2010-03-08 00:00:00 | 2010-03-16 00:00:00 |
| 2010-03-08 00:00:00 | 2010-03-22 00:00:00 |
| 2010-03-10 00:00:00 | 2010-03-24 00:00:00 |
| 2010-03-18 00:00:00 | 2010-03-27 00:00:00 |
| 2010-03-30 00:00:00 | 2010-04-05 00:00:00 |
+———————+———————+

找出在三月的活动日期(所谓活动日期就是在start_time以及end_time 之间的日期

所以结果是 4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,30

Posted in: 算法研究

This entry was posted on 星期六, 三月 6th, 2010 at 8:33 下午 and is filed under 算法研究. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.