Top "Intervals" questions

Intervals are used to measure “distance” between values.

oracle to_date with format doesn't show time

I have simple calculation, I subtract interval from date with time: select TO_DATE('2016-12-05 23:04:59', 'YYYY-MM-DD HH24:…

oracle format intervals to-date
Overlapping Intervals

Assume that you are given a set of intervals (not necessarily integral in length). How do you determine if there …

algorithm intervals
Terminate a thread after an interval if not returned

I have a thread which grabs some data from network or serial port. The thread must terminate (or return false) …

c# .net multithreading intervals terminate
SQL: Merge Date Ranges

I've a table, which describes work slices of a business working calendar: (date format is 24 hours format) PK | STARTDATE | ENDDATE __________________________________________ 1 | 2012/07/21 02:00 | 2012/07/21 04:00 2 | 2012/07/21 03:00 | 2012/07/21 10:00 3 | 2012/07/21 06:00 | 2012/07/21 17:00 4 | 2012/07/21 18:00 | 2012/07/21 19:00 …

sql date intervals range
StopWatch vs Timer - When to Use

Forgive me for this question, but I can't seem to find a good source of when to use which. Would …

c# time timer intervals stopwatch
Interval datatype in Pandas - find midpoint, left, center etc

In pandas 20.1, with the interval type, is it possible to find the midpoint, left or center values in a series. …

python pandas intervals
Union of intervals

I've got a class representing an interval. This class has two properties "start" and "end" of a comparable type. Now …

union intervals
SQL Server : populate table in 15 minute intervals

I need to populate a table in SQL Server with an ID column and a TimeValue column with 15 minute intervals …

sql-server datetime intervals populate
Count the number of records active between two dates

I am trying to do a query to retreive the number of active calls for a given time, I have …

sql sql-server date intervals between
Finding "maximum" overlapping interval pair in O(nlog(n))

Problem Statement Input set of n intervals; {[s_1,t_1], [s_2,t_2], ... ,[s_n,t_n]}. Output pair of intervals; {[s_…

algorithm sorting search intervals