我有两个子查询,它们给我一个由日期组成的结果. 我想计算一下它们之间的差额.
例如:
SELECT DATEDIFF(
DAY,
(SELECT MAX(invoices.date) FROM invoices WHERE invoices.orderno = odH.orderno),
(SELECT min(history.date) FROM history WHERE history.orderno = odH.orderno)
) ...
我有两个子查询,它们给我一个由日期组成的结果. 我想计算一下它们之间的差额.
例如:
SELECT DATEDIFF(
DAY,
(SELECT MAX(invoices.date) FROM invoices WHERE invoices.orderno = odH.orderno),
(SELECT min(history.date) FROM history WHERE history.orderno = odH.orderno)
) ...
要计算postgres中两个日期之间的差异,只需将一个日期减go 另一个日期即可.以下是修改查询的方法:
SELECT (SELECT MAX(INVOICE.date) FROM INVOICES WHERE INVOICES.orderno = odH.orderno) - (SELECT min(history.date) FROM history WHERE history.orderno = ODH.orderno)
这将为您提供给定订单号的最大发票日期和最小历史日期之间的天数差.