Stack Overflow
Stack Overflow

Questions tagged [intervals]

Intervals are used to measure “distance” between values.

Intervals are used to measure “distance” between values.

In the DBMS world interval typically refers to the period between 2 timestamps, many modern RDBMS systems natively supports intervals and operation with them.

More information on the intervals can be found in the wild.

2903 questions
0
votes
0 answers

Trigger API call every hour

I have an Alamofire function that calls an API. How do I make this function trigger every hour since the first time the function is triggered? I currently have this function but looks like this code is work with delay of 1 hour after it's called. I…
afi permana
  • 207
  • 3
  • 17
0
votes
0 answers

In a database that stores intervals, how to build indexes to find the intervals that overlaps a given interval?

Suppose I have a table Event for a calendar app: event_id, start_time, end_time I want to find all the events that overlap with a given range [s0, e0]. In a calendar App this can be used to retrieve meetings in a week, for example. How to build…
Patrick
  • 555
  • 1
  • 6
  • 25
0
votes
0 answers

How to display minutes with 15mins interval

In this case, I would like to change the time interval to every 15min, like 1:00,1:15,1:30,1:45 in the right hand side selection part. which will display 00,15,30,45 only instead of 30,31,32 like shown in the photo. The step="900" attribute does not…
Andy Qu
  • 1
0
votes
1 answer

confidence intervals (bootstrap in r)

I have a vector of 19 values. I want to calculate confidence intervals for each value using the bootstrap method. I use the following code: library(boot) alpha <- 0.9 B <- 1000 p_hat<-s$a #vector with 19 values intervals <- matrix(0, ncol = 2,…
Olesia
  • 1
  • 1
0
votes
1 answer

How can I operate with an interval type variable?

I have two timestamp columns('tpep_pickup_datetime' and 'tpep_dropoff_datetime') and when I calculate the difference between them, I get an interval variable. yellowcab = yellowcab \ .withColumn('tpep_pickup_datetime',…
Migue
  • 1
  • 1
0
votes
1 answer

Google Spanner Postgres DB fetch Last 5 hours data

I have a table with 3 columns Id, Data, Date. Date has dataType timestamp with time zone. I want to get last 5 hours created ids Query. I tried with interval query Select Id from table where date > (current_date - INTERVAL '5 hour') It is…
Sneha Mule
  • 641
  • 8
  • 6
0
votes
1 answer

How to use setInterval and clearInterval for a simple slideshow jQuery

i managed to get a simple slideshow working that has two main "features": automatically sliding to the next image showing the desired image on clicking the according indicator the interval is set to display the next image after 5 seconds. however,…
stizzle
  • 17
  • 4
0
votes
0 answers

Expecting several lines of output, why am I getting only one line?

Why does my class interval output only one when I enter 10 or more data? I use while loop here. What's missing? num= min; while (num <=max){ cout<< "class interval"<< endl; cout << num <
Elara Pisces
  • 1
0
votes
1 answer

How does date_add and interval works in MySQL?

I try to select those rows from the table in which datatime is withing 1 minute from now. I try to do it in the following way: SELECT datetime FROM my_table WHERE datetime > date_add( curdate( ) , INTERVAL -1 MINUTE ) This is what I…
Roman
  • 124,451
  • 167
  • 349
  • 456
0
votes
1 answer

Creation and visualization of isochrones in the road network from the police station in intervals: 2,5,10,15 min, if the speed of movement is 40km/h

Here is the code which I have created for interval 2minutes select ways.the_geom from (WITH distance_query AS ( SELECT *, (length / 1000) / (30 / 3600) AS time_in_seconds FROM ways ) SELECT * FROM…
Dardan
  • 21
  • 3
0
votes
1 answer

how to schedule a prefect flow that runs on first Tuesday of each month at 18:00 IST in prefect 1.x?

I want to set a schedule in prefect 1.x so that it starts the flow only on 1st Tuesday of each Monday, using code, I'd also like to see a way of doing this if I have a set of custom dates I want to run it on. I couldn't do it since cron does not…
atharva narwane
  • 11
  • 1
0
votes
1 answer

How to adjust list interval in xticks?

I have data where I want to plot their timeseries. The FRQ is the column bar and the FILT is the line chart. YEAR FRQ FILT 1960 1 1961 3 1962 1 1.416666667 1963 1 0.916666667 1964 0 0.833333333 1965 1 …
user2543
  • 121
  • 9
0
votes
1 answer

Converting time interval to Date or number in React

Is anyone aware of a library I can use in React that converts locale aware time interval to either Date interval or a number (e.g., a number of seconds). For instance: "2min" -> 120 "2 minutes" -> 120 "2 Minuten" -> 120 (locale: de) and so on. Can…
Vlad Z
  • 383
  • 2
  • 12
0
votes
1 answer

Splitting MJPEG RTSP stream into multi files - GSTREAMER

I have an Xavier AGX dev kit and x4 AGXs I hope to replicate this pipeline on. I am serving the RTSP stream to _my_ip_address:8554/test. I can see it on other computers and VLC no problem. The stream itself is MJPEG. I am not doing h264 because my…
Milesk1990
  • 1
0
votes
3 answers

interval starting two times

When the user clicks a button an interval will start counting but the problem is that if the user clicks the button two times there will be two intervals I tried clearInterval(interval); before assigning the interval but the timer stopped…
josefh weszla
  • 3
  • 3
1 2 3
…
99 100