Skip to content

Not able to query lastest data ordered by ts / Interval #57

@WYXF007

Description

@WYXF007

Hi,

I executed the following query and received an empty result:
SELECT * FROM vrf_v2_events WHERE ts >= NOW() - INTERVAL '2 days' LIMIT 100;

It seems that I can no longer query data with a later timestamp using the ts column. Is there a way to retrieve the most recent data in a time-ordered manner?

Thank you for your help.

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type
    No fields configured for issues without a type.

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions