All Questions
Tagged with postgresql datetime
5 questions
2
votes
1
answer
56
views
Find coherent datetime ranges in postgresql
My Data consists of rows containing a Length/Duration in Minutes, a Begin & EndTime. The precision is 1min (or larger).
the table looks something like that:
...
- 121
3
votes
1
answer
62
views
Iterate between dates and INSERT values in a performant way
I have created a query that populates a datapoint with random values.
The logic is simple: Iterate between the START and END dates and INSERT random values.
I want from this query to be very ...
- 461
2
votes
0
answers
187
views
PostgreSQL: maintaining non-overlapping temporal ranges
I have to store some temporal meta data used primarily in bulk processing of a time-series (sensor measurements).
Each value of this meta data is valid for a potentially half-open range of time.
...
- 21
2
votes
1
answer
122
views
Checking whether a store is open or not by querying over its business hours
I currently have a method that checks if the store is open. It's working nicely, however on the main page I have quite a few stores. Whom again have different locations. Each of these locations again ...
4
votes
1
answer
58
views
SQL report of subscribers and their associated revenue
A user can have many subscriptions, and a subscription belongs to one plan. The plans table tells us a subscription's cost. Is the query below the correct one for ...
- 141