sql中的日期... [英] datediffer in sql...

问题描述

如果我从2014-03-14到2014-04-06选择日期......那么我想要几天的日数

if i select date from 2014-03-14 to 2014-04-06...then i want days count of perticular months

推荐答案

你的意思是：

Do you mean:

SELECT COUNT(*) FROM MyTable WHERE insertDate BETWEEN '2014-03-14' AND '2014-04-06'

如果没有，请尝试更详细地解释一下 - 或许举个例子？

If not, please try to explain in more detail - perhaps with an example?

SELECT DATEDIFF(dd,'2014-03-14', '2014-04-06') AS CountOfDaysBetweenDates

更多： DATEDIFF [ ^ ]

More: DATEDIFF[^]

SELECT CONVERT(VARCHAR(7),entry_date,121) AS PeriodOfTime, COUNT(*) as footfall, sum(amount)/(SELECT DATEPART(dd, DATEADD(dd, DATEPART(dd, DATEADD(mm, 1, max(GE.Active_Date))) * -1, DATEADD(mm, 1,max(GE.Active_Date))))) Avgamount
FROM guest_tbl
WHERE entry_date between '2014-03-14' AND '2014-04-06'
GROUP BY CONVERT(VARCHAR(7),entry_date,121)

[/ EDIT]

[/EDIT]

这篇关于sql中的日期...的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！