生日报表关于时间的处理

最新推荐文章于 2025-06-01 14:49:39 发布

原创最新推荐文章于 2025-06-01 14:49:39 发布 · 158 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#C #C++ #C# #MySQL #SQL

birt report 专栏收录该内容

1 篇文章

订阅专栏

需求：从contact表中搜索出时间段是2010-11-12到2011-03-12的联系人
使用mysql时间函数来构造sql放到birt的query里面
sql：

select * from contact c where 
(DATE_ADD(c.birthday,INTERVAL (YEAR(NOW())-YEAR(c.birthday)) YEAR)  >= '2010-11-12 00:00:00' 
and  DATE_ADD(c.birthday,INTERVAL (YEAR(NOW())-YEAR(c.birthday)) YEAR) <= '2011-03-12 00:00:00' ) 
or  (DATE_ADD(c.birthday,INTERVAL (YEAR(NOW())-YEAR(c.birthday)+1) YEAR)  >= '2010-11-12 00:00:00' 
and  DATE_ADD(c.birthday,INTERVAL (YEAR(NOW())-YEAR(c.birthday)+1) YEAR) <= '2011-03-12 00:00:00' )