Question : I have a bunch of time intervals that I would like to analyze. (Thousands of them.) They range […]
Tag: interval
How to add a generated column with an expression subtracting days?
Question : I have this table in PostgreSQL 13: CREATE TABLE public.”domain” ( id int8 NOT NULL GENERATED ALWAYS AS […]
Select all overlapping ranges from starting range
Question : My question is similar to this one with (I think) significant enough difference. I have a base range […]
Computing the set difference of tables of intervals
Question : I often run into the following problem. I have two tables of intervals. They are bounded by dates […]
MySQL – Merge or split datetime intervals (start date to end date)
Question : I have a table which stores a list of activities with an interval of time delimited by 2 […]
Return hours, minutes and seconds left if column wasn’t updated
Question : I currently have this query: UPDATE MyTable SET next_update = now() at time zone ‘utc’ WHERE next_update::timestamp < […]
operator does not exist: interval < date
Question : I want to do the following comparison : IF ( V_C_CRITERE2.DATE_FIN_SOUHAITEE – TO_DATE(V_SEUIL_ALERT) < CURRENT_DATE) THEN DATE_FIN_SOUHAITEE is […]
Flag Rows Occurring 2 Hours After Previous Flag
Question : I have some messy RFID data due to over sensitive antenna’s. There is a physical process that tracks […]
How do I round time to the upper multiple of an arbitrary time interval?
Question : Example: If the current time is 2018-05-17 22:45:30 and the desired interval is INTERVAL ‘5 minute’, then the […]
Convert overlapping datetime ranges into non-overlapping ranges with priorities
Question : I have data stored in a table like this: CREATE TABLE Records ( [Id] int IDENTITY(1,1) not null […]
- 1
- 2