获取日期差异

Question

嗨，我有两个专栏

PR_PurchaseRequestHistory    

1)uid                        
2)POUID                       
3)PRUID                        
4)PRDUID                      
5)CreatedDtTm                  
6)ModifiedDtTM

PO_PurchaseOrderDetails
1)uid   
2)PRUid
3)RespondedDtTm   
4)ModifiedDtTm
5)CreatedDtTm

(唯一PRUId)分配给每个新请求，并为该PRUId下订单POUId。我需要获得为特定月份生成的ID的平均日期差异

我认为这让问题变得清晰起来，请帮助我。我被这个问题困扰了很长一段时间

Answer 1

SELECT AVG(HOUR(TIMEDIFF(PO_PurchaseOrderDetails.RespondedDtTm, PR_PurchaseRequestHistory.CreatedDtTm)))
FROM PR_PurchaseRequestHistory
INNER JOIN PO_PurchaseOrderDetails ON PR_PurchaseRequestHistory.PRUID = PO_PurchaseOrderDetails.PRUID
WHERE MONTH(PR_PurchaseRequestHistory.CreatedDtTm) = 3 -- March
AND YEAR(PR_PurchaseRequestHistory.CreatedDtTm) = 2011