如何在postgreSQL中获取最后24小时的数据

发布时间：2020-12-13 18:04:50 所属栏目：百科来源：网络整理

导读：我想获得最后24小时的数据.我在postgreSQL中写了一个查询,如下所示.但我无法按照我的预期得到答案. SELECT startdate::timestamp AS startdate,(DATE_PART('hour',startdate::timestamp)::integer) as hrs,count(guorderid) FROM ord_entitlement WHERE DATE

我想获得最后24小时的数据.我在postgreSQL中写了一个查询,如下所示.但我无法按照我的预期得到答案.

SELECT startdate::timestamp AS startdate,(DATE_PART('hour',startdate::timestamp)::integer) as hrs,count(guorderid)
    FROM ord_entitlement
    WHERE DATE_PART('Day',CURRENT_DATE::timestamp - startdate::timestamp) < 1
    AND DATE_PART('hour',startdate::timestamp) <= 24
    GROUP BY  hrs,startdate
    ORDER BY startdate

如果您使用CURRENT_DATE,则不会使用now()函数.试试以下,

SELECT startdate::timestamp AS startdate,count(guorderid)
        FROM ord_entitlement
        WHERE DATE_PART('Day',now() - startdate::timestamptz) < 1
        GROUP BY  hrs,startdate
        ORDER BY startdate

（编辑：李大同）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!