我们如何在火鸟中做每周一次的靶场小组？

Question

我对Firebird中的一些脚本有问题。我想把我的约会安排在周六开始的周类中，但遗憾的是，最后一天的位置不对。

SELECT
    dateadd(week, DATEDIFF(week, date '1-1-1900', cast(s.NNDate as date)),date '1-6-1900') AS Week_Clm,
    cast(s.NNDate as date), Menge
FROM
(
    SELECT cast(New_DATUM AS date) AS NNDate, sum(LGL_MENGE) AS Menge
    FROM View_LAGERLOG
    WHERE (  LGL_REFNUMMER = '0' OR
             LGL_REFNUMMER = '1' OR
             LGL_REFNUMMER = '2' OR
             LGL_REFNUMMER = '3' OR
             LGL_REFNUMMER = '4')
    GROUP BY cast(New_DATUM as date)
) s 

​

]1

Answer 1

查看Firebird中的提取函数。用Firebird 3.0测试：

select
  extract (year from current_date) as dyear,
  extract (week from current_date) as dweek
from rdb$database

您可以将它们作为一个字段连接起来，以便以后进行数据管理。