community.questdb.com/t/counting-entries-based-on-timestamps/860

Preview meta tags from the community.questdb.com website.

Linked Hostnames

3

Thumbnail

Search Engine Appearance

Google

https://community.questdb.com/t/counting-entries-based-on-timestamps/860

Counting entries based on timestamps

Hi! I’m trying to create a query to get some entries in my QuestDB based on some time ranges. The table I have is defined as sessionId (string) | startTime (timestamp) | endTime (timestamp) On any timerange given, whi…



Bing

Counting entries based on timestamps

https://community.questdb.com/t/counting-entries-based-on-timestamps/860

Hi! I’m trying to create a query to get some entries in my QuestDB based on some time ranges. The table I have is defined as sessionId (string) | startTime (timestamp) | endTime (timestamp) On any timerange given, whi…



DuckDuckGo

https://community.questdb.com/t/counting-entries-based-on-timestamps/860

Counting entries based on timestamps

Hi! I’m trying to create a query to get some entries in my QuestDB based on some time ranges. The table I have is defined as sessionId (string) | startTime (timestamp) | endTime (timestamp) On any timerange given, whi…

  • General Meta Tags

    9
    • title
      Counting entries based on timestamps - QuestDB Community
    • charset
      utf-8
    • description
      Hi! I’m trying to create a query to get some entries in my QuestDB based on some time ranges. The table I have is defined as sessionId (string) | startTime (timestamp) | endTime (timestamp) On any timerange given, whi…
    • generator
      Discourse 3.5.0.beta9-dev - https://github.com/discourse/discourse version 028c90dd5e7a2799ea5b6e963f71fc0222681943
    • theme-color
      #ffffff

  • Open Graph Meta Tags

    10
    • og:site_name
      QuestDB Community
    • og:type
      website
    • og:image
      https://canada1.discourse-cdn.com/flex004/uploads/questdb/original/1X/af6309f2d2e2039ffd95e0f4b1d6a9dedeeb94ef.svg
    • og:url
      https://community.questdb.com/t/counting-entries-based-on-timestamps/860
    • og:title
      Counting entries based on timestamps

  • Twitter Meta Tags

    8
    • twitter:card
      summary
    • twitter:url
      https://community.questdb.com/t/counting-entries-based-on-timestamps/860
    • twitter:title
      Counting entries based on timestamps
    • twitter:description
      Hi! I’m trying to create a query to get some entries in my QuestDB based on some time ranges. The table I have is defined as sessionId (string) | startTime (timestamp) | endTime (timestamp) On any timerange given, which i assume I have to compute using the timestamp_sequence function, i want to know the number of alive sessions in that time. An alive session is a session which started (startTime) before or in the given timestamp and ended (endTime) after the given timestamp. For example, for...
    • twitter:label1
      Reading time

  • Item Prop Meta Tags

    46
    • position
      1
    • headline
      Counting entries based on timestamps
    • datePublished
      2025-06-13T17:50:01Z
    • articleSection
      Community
    • keywords
      question

  • Link Tags

    34
    • alternate nofollow
      https://community.questdb.com/t/counting-entries-based-on-timestamps/860.rss
    • apple-touch-icon
      https://canada1.discourse-cdn.com/flex004/uploads/questdb/optimized/1X/3f9f1a37461059c7519d32a73a4ed0ebd5d80402_2_180x180.png
    • canonical
      https://community.questdb.com/t/counting-entries-based-on-timestamps/860
    • icon
      https://canada1.discourse-cdn.com/flex004/uploads/questdb/optimized/1X/e02c1039a8e20c27b120443338c982d665802864_2_32x32.png
    • search
      https://community.questdb.com/opensearch.xml

Links

21