softech To get the accurate results, you can use the following query.
select post_time, post_time_friendly from messages where post_time>=2024-04-01T00:00:00.000-00:00 and post_time <= 2024-05-01T23:59:59.999-00:00
thanks HariniVuppala
and one more question, can i use max and min on my query?
like
select max(id) from messages where post_time>=2024-04-01T00:00:00.000-00:00 and post_time <= 2024-05-01T23:59:59.999-00:00
I got an error using max(id) or min(id)
thanks
softech
Max and min is not allowed. Can you please clarify what do you want to achieve by using max and min.
If you want to get the maximum number of messages in single query then you have to use limit. By default it returns 25 results.
select id from messages where post_time>=2024-04-01T00:00:00.000-00:00 and post_time <= 2024-05-01T23:59:59.999-00:00 limit 999
For next batch, you have to pass the offset as below
select id from messages where post_time>=2024-04-01T00:00:00.000-00:00 and post_time <= 2024-05-01T23:59:59.999-00:00 limit 999 offset 1
