1

I have a lot of time-series data stored in a GridDB database, and I want to query it using SQL. However, I don't know the syntax for selecting data based on a time range.

Here's what I have so far:

 SELECT * FROM my_container WHERE timestamp >= '2022-01-01' AND timestamp <= '2022-01-31'
SimoIT
  • 79
  • 4
  • What is the format of your `timestamp` column ? – Tushar Mar 12 '23 at 06:03
  • 1
    Does this work for you ? `SELECT * FROM my_container WHERE timestamp > TIMESTAMP('2022-01-01') AND timestamp <= TIMESTAMP('2022-01-31');` – Tushar Mar 12 '23 at 07:27

0 Answers0